First page Back Continue Last page Graphics

ORDERED Hint

Notes:

As demonstrated here, the ORDERED hint can be used to fix the problem we encountered in the last example where CBO chose the wrong table as the driving table in the nested loops join. Note the much reduced logical I/O’s and CPU and elapsed times.
Refer to the supplied files nested_loops.sql, nested_loops_trace.txt and nested_loops_10053.sql for a demonstration of this and other nested loops concepts.