------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 1 | 601 | 4 (0)| 00:00:01 | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10005 | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,05 | P->S | QC (RAND) | | 3 | HASH GROUP BY | | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,05 | PCWP | | | 4 | PX RECEIVE | | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,05 | PCWP | | | 5 | PX SEND HASH | :TQ10004 | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,04 | P->P | HASH | | 6 | HASH GROUP BY | | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,04 | PCWP | | |* 7 | HASH JOIN | | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,04 | PCWP | | | 8 | PX RECEIVE | | 1 | 522 | 3 (0)| 00:00:01 | | | Q1,04 | PCWP | | | 9 | PX SEND HASH | :TQ10003 | 1 | 522 | 3 (0)| 00:00:01 | | | Q1,03 | P->P | HASH | | 10 | BUFFER SORT | | 1 | 601 | 4 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 11 | NESTED LOOPS | | 1 | 522 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 12 | NESTED LOOPS | | 1 | 494 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 13 | NESTED LOOPS | | 1 | 474 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 14 | NESTED LOOPS | | 1 | 410 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 15 | NESTED LOOPS | | 1 | 392 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 16 | NESTED LOOPS | | 1 | 366 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | |* 17 | HASH JOIN | | 1 | 302 | 3 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 18 | BUFFER SORT | | | | | | | | Q1,03 | PCWC | | | 19 | PX RECEIVE | | 1 | 146 | 1 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 20 | PX SEND HASH | :TQ10000 | 1 | 146 | 1 (0)| 00:00:01 | | | | S->P | HASH | | 21 | NESTED LOOPS | | 1 | 146 | 1 (0)| 00:00:01 | | | | | | | 22 | NESTED LOOPS | | 1 | 146 | 1 (0)| 00:00:01 | | | | | | | 23 | PARTITION HASH SINGLE | | 1 | 79 | 1 (0)| 00:00:01 | 6 | 6 | | | | | 24 | TABLE ACCESS BY LOCAL INDEX ROWID| S_USER_FAF | 1 | 79 | 1 (0)| 00:00:01 | 6 | 6 | | | | | 25 | BITMAP CONVERSION TO ROWIDS | | | | | | | | | | | |* 26 | BITMAP INDEX SINGLE VALUE | S_USER_FAF_2 | | | | | 6 | 6 | | | | | 27 | PARTITION HASH ITERATOR | | 1 | | 0 (0)| 00:00:01 | KEY | KEY | | | | |* 28 | INDEX UNIQUE SCAN | R_MAT_D_PK | 1 | | 0 (0)| 00:00:01 | KEY | KEY | | | | | 29 | TABLE ACCESS BY LOCAL INDEX ROWID | R_MAT_D | 1 | 67 | 0 (0)| 00:00:01 | 1 | 1 | | | | | 30 | PX RECEIVE | | 1 | 156 | 2 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 31 | PX SEND HASH | :TQ10002 | 1 | 156 | 2 (0)| 00:00:01 | | | Q1,02 | P->P | HASH | | 32 | PX BLOCK ITERATOR | | 1 | 156 | 2 (0)| 00:00:01 | 1 | 32 | Q1,02 | PCWC | | | 33 | TABLE ACCESS FULL | PL_MVP_C_F | 1 | 156 | 2 (0)| 00:00:01 | 1 |1048575| Q1,02 | PCWP | | | 34 | PARTITION HASH ITERATOR | | 1 | 64 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 35 | TABLE ACCESS BY LOCAL INDEX ROWID | SI_D | 1 | 64 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | |* 36 | INDEX UNIQUE SCAN | SI_PK | 1 | | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 37 | TABLE ACCESS BY INDEX ROWID | CON_D | 1 | 26 | 0 (0)| 00:00:01 | | | Q1,03 | PCWP | | |* 38 | INDEX UNIQUE SCAN | CON_PK | 1 | | 0 (0)| 00:00:01 | | | Q1,03 | PCWP | | |* 39 | TABLE ACCESS BY INDEX ROWID | D_MONTH | 1 | 18 | 0 (0)| 00:00:01 | | | Q1,03 | PCWP | | |* 40 | INDEX UNIQUE SCAN | D_MONTH_PK | 1 | | 0 (0)| 00:00:01 | | | Q1,03 | PCWP | | | 41 | PARTITION HASH ITERATOR | | 1 | 64 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 42 | TABLE ACCESS BY LOCAL INDEX ROWID | SI_D | 1 | 64 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | |* 43 | INDEX UNIQUE SCAN | SI_D_PK | 1 | | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 44 | PARTITION HASH ITERATOR | | 1 | 20 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 45 | TABLE ACCESS BY LOCAL INDEX ROWID | F_C_D | 1 | 20 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | |* 46 | INDEX UNIQUE SCAN | F_C_D_PK | 1 | | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 47 | PARTITION HASH ITERATOR | | 1 | 28 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 48 | TABLE ACCESS BY LOCAL INDEX ROWID | PRO_D | 1 | 28 | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | |* 49 | INDEX UNIQUE SCAN | PRO_D_PK | 1 | | 0 (0)| 00:00:01 | KEY | KEY | Q1,03 | PCWP | | | 50 | BUFFER SORT | | | | | | | | Q1,04 | PCWC | | | 51 | PX RECEIVE | | 1 | 79 | 1 (0)| 00:00:01 | | | Q1,04 | PCWP | | | 52 | PX SEND HASH | :TQ10001 | 1 | 79 | 1 (0)| 00:00:01 | | | | S->P | HASH | | 53 | PARTITION HASH SINGLE | | 1 | 79 | 1 (0)| 00:00:01 | 6 | 6 | | | | | 54 | TABLE ACCESS BY LOCAL INDEX ROWID | S_USER_FAF | 1 | 79 | 1 (0)| 00:00:01 | 6 | 6 | | | | | 55 | BITMAP CONVERSION TO ROWIDS | | | | | | | | | | | |* 56 | BITMAP INDEX SINGLE VALUE | S_USER_FAF_2 | | | | | 6 | 6 | | | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------