Sorts input row sources into groups or partitions. Used in partitioned outer joins
This operation is implemented in the following versions
|
This example was developed using Oracle 10.2.0.1 on Linux
This example requires the following table definitions
CREATE TABLE t1 (c1 NUMBER,c2 NUMBER); CREATE TABLE t2 (c1 NUMBER,c2 NUMBER);
The statement
SELECT t1.c2,t2.c2 FROM t1 PARTITION BY (c2) RIGHT JOIN t2 ON (t1.c1 = t2.c1);
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 VIEW 2 1 NESTED LOOPS (PARTITION OUTER) 3 2 BUFFER (SORT) 4 3 TABLE ACCESS (FULL) OF 'T2' 5 2 FILTER 6 5 SORT (PARTITION JOIN) 7 6 TABLE ACCESS (FULL) OF 'T1'