Index hint oracle syntax
Re: correct index hint syntax Centinul Aug 24, 2012 6:32 PM ( in response to 810790 ) The documentation was explicit about how to properly format comments to be interpreted as hints. The Index hint explains how the optimizer scans a specified index rather than a table. If queries against the ORDER_ITEMS table are slow, you can review the execution plan of the query optimizer. If the FAST_INDEX was not used, you can create an Index hint to force the optimizer to scan the FAST_INDEX rather than the ORDER_ITEMS table. The syntax for the Index hint is as follows: