Parallel execution - send range of rows to parent process
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 ) PARALLEL 2;
The statement
CREATE INDEX i1 ON t1 (c1) PARALLEL 2;
generates the following execution plan
0 CREATE INDEX STATEMENT 1 0 PX COORDINATOR 2 1 PX SEND (QC (ORDER)) 3 2 INDEX BUILD (NON UNIQUE) 4 3 SORT (CREATE INDEX) 5 4 PX RECEIVE 6 5 PX SEND (RANGE) 7 6 PX BLOCK ITERATOR 8 7 TABLE ACCESS (FULL) OF 'T1'