First page Back Continue Last page Graphics

Hash Join Example

Notes:

This TKPROF excerpt shows that CBO chose the smaller table as the driver.
Refer to the supplied script hash_join.sql and trace output hash_join_trace.txt for more details regarding the demonstrations shown here.