This content has been marked as final. Show 6 replies
I am trying to use hints on imported tables in physical layer.
I am specifying a index hint such as INDEX(TABLE_NAME INDEX_NAME)
When the BI server generates a query the physical query omits the index name but uses a hint like INDEX(TABLE_NAME)
Any reason why its omitting the Index name?
How to fix the problem and make BI server issue the hint as entered when generating the query?