6 Replies Latest reply: May 15, 2014 5:48 PM by 10111001 RSS

    Hints in Physical Layer

    10111001

      Hello,

       

      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?

       

      Help appreciated.