Query block hints operate on single query blocks. Note that USE_NL (table1 table2) is not considered a multi-table hint because it is actually a shortcut for USE_NL(table1) and USE_NL(table2). LEADING is an example of a multi-table hint. Multi-table hints are like single-table hints, except that the hint can specify one or more tables or views. INDEX and USE_NL are examples of single-table hints. Single-table hints are specified on one table or view. Hints falls into the following general classifications:
0 Comments
Leave a Reply. |