Explained PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- Plan hash value: 1303356951 -------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |Tem -------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1583K| 31M| | 1 | SORT UNIQUE | | 1583K| 31M| | 2 | UNION-ALL | | | | |* 3 | CONNECT BY WITH FILTERING | | | | | 4 | TABLE ACCESS BY INDEX ROWID| TT_CFS_ASSOC_CFS | | | |* 5 | HASH JOIN | | 7837K| 209M| | 6 | NESTED LOOPS | | 1583K| 31M| | 7 | TABLE ACCESS FULL | TT_CFS_REALISE_RFS | 11M| 149M| | 8 | VIEW | | 1 | 7 | | 9 | SORT UNIQUE | | | | | 10 | UNION-ALL PARTITION | | | | |* 11 | INDEX RANGE SCAN | SYS_C0050935 | 1 | 7 | |* 12 | INDEX RANGE SCAN | SYS_C00221036 | 1 | 7 | |* 13 | INDEX RANGE SCAN | SYS_C00405454 | 1 | 7 | | 14 | TABLE ACCESS FULL | TT_CFS_ASSOC_CFS | 14M| 97M| PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- | 15 | NESTED LOOPS | | | | | 16 | CONNECT BY PUMP | | | | |* 17 | INDEX RANGE SCAN | SYS_C0050602 | 11 | 154 | | 18 | NESTED LOOPS | | 1583K| 31M| | 19 | TABLE ACCESS FULL | TT_CFS_REALISE_RFS | 11M| 149M| | 20 | VIEW | | 1 | 7 | | 21 | SORT UNIQUE | | | | | 22 | UNION-ALL PARTITION | | | | |* 23 | INDEX RANGE SCAN | SYS_C0050935 | 1 | 7 | |* 24 | INDEX RANGE SCAN | SYS_C00221036 | 1 | 7 | |* 25 | INDEX RANGE SCAN | SYS_C00405454 | 1 | 7 | -------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("TT_CFS_ASSOC_CFS"."FK_FROM_CFS"=PRIOR "TT_CFS_ASSOC_CFS"."FK_TO_C 5 - access("TT_CFS_ASSOC_CFS"."FK_FROM_CFS"="TT_CFS_REALISE_RFS"."FK_FROM_CFS 11 - access("TTE"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") 12 - access("TTA"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") 13 - access("TTP"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- 17 - access("TT_CFS_ASSOC_CFS"."FK_FROM_CFS"=PRIOR "TT_CFS_ASSOC_CFS"."FK_TO_C 23 - access("TTE"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") 24 - access("TTA"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") 25 - access("TTP"."FK_FROM_RFS"="TT_CFS_REALISE_RFS"."FK_TO_RFS") 45 rows selected