First page Back Continue Last page Graphics
Adding Selective Filters
Adding additional filters can change the join order
Notes:
This TKPROF excerpt shows that by adding a selective filter on BIG.OBJECT_TYPE, CBO sees the BIG table as the smaller of the two tables and correctly uses it as the driver.
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.