First page Back Continue Last page Graphics

Sort-Merge Example

Notes:

This example demonstrates that the Oracle9i optimizer will sometimes choose a sort-merge join when the join condition is not an equal condition (it could choose a nested loops). Note that the process involves two sorts, one for each table source.
Refer to the supplied script sort_merge_join.sql and trace file sort_merge_join_trace.sql for more details and statistics on the sort merge join shown here.