The low-level options allow the inclusion or exclusion of fine details, such as predicates and cost. The example in Figure 5 displays the basic execution plan and includes information on any predicates as well as the Optimizer Cost column. SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY...
This type of join is done by sorting the rows from each table by the join columns. Once the two rowsets have been sorted, Oracle reads through both and joins any matching rows together. A merge may use fewer resources than the other options, but you have to wait for all the records t...