CIRQIT@XENON> sta noinline.sql Execution Plan ---------------------------------------------------------- Plan hash value: 1638279263 -------------------------------------------------------------------------------- ------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------- ------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 8295 | 135 (6)| 00:00:02 | | 1 | SORT ORDER BY | | 1 | 8295 | 135 (6)| 00:00:02 | | 2 | NESTED LOOPS SEMI | | 1 | 8295 | 134 (5)| 00:00:02 | | 3 | NESTED LOOPS | | 1 | 8285 | 132 (5)| 00:00:02 | | 4 | NESTED LOOPS | | 1 | 8254 | 131 (5)| 00:00:02 | | 5 | NESTED LOOPS | | 1 | 8175 | 129 (5)| 00:00:02 | | 6 | NESTED LOOPS | | 1 | 8147 | 128 (5)| 00:00:02 | |* 7 | HASH JOIN | | 1 | 8096 | 126 (5)| 00:00:02 | |* 8 | HASH JOIN | | 1 | 6072 | 94 (5)| 00:00:02 | |* 9 | HASH JOIN | | 1 | 4048 | 63 (5)| 00:00:01 | | 10 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 11 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 12 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 13 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 14 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 15 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 16 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 17 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 18 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_IND X | 26 | | 4 (0)| 00:00:01 | |* 19 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 2 (0)| 00:00:01 | |* 20 | INDEX RANGE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 1 (0)| 00:00:01 | |* 21 | INDEX UNIQUE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 1 (0)| 00:00:01 | | 22 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 23 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 24 | NESTED LOOPS | | | | | | | 25 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 26 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 27 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 28 | TABLE ACCESS BY INDEX ROWID| PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 29 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 30 | TABLE ACCESS BY INDEX ROWID| ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 31 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_IND X | 26 | | 4 (0)| 00:00:01 | |* 32 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 33 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 34 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 35 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 36 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 37 | NESTED LOOPS | | | | | | | 38 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 39 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 40 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 41 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 42 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 43 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 44 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_IND X | 26 | | 4 (0)| 00:00:01 | |* 45 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 46 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 47 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | | 48 | VIEW | | 1 | 2024 | 31 (4)| 00:00:01 | | 49 | SORT ORDER BY | | 1 | 148 | 31 (4)| 00:00:01 | | 50 | NESTED LOOPS | | | | | | | 51 | NESTED LOOPS | | 1 | 148 | 30 (0)| 00:00:01 | | 52 | NESTED LOOPS | | 1 | 127 | 29 (0)| 00:00:01 | | 53 | NESTED LOOPS | | 1 | 106 | 27 (0)| 00:00:01 | | 54 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 36 | 2 (0)| 00:00:01 | |* 55 | INDEX RANGE SCAN | PBVORG_PARENT_INDX | 1 | | 1 (0)| 00:00:01 | |* 56 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 70 | 25 (0)| 00:00:01 | |* 57 | INDEX RANGE SCAN | JOB_STAGE_CLNT_DATE_REQ_IND X | 26 | | 4 (0)| 00:00:01 | |* 58 | INDEX RANGE SCAN | ESTIMATE_CUSTOM_FIELD_PK | 1 | 21 | 2 (0)| 00:00:01 | |* 59 | INDEX UNIQUE SCAN | ORG_CUSTOM_FIELD_MAP_PK | 1 | | 0 (0)| 00:00:01 | | 60 | TABLE ACCESS BY INDEX ROWID | ORG_CUSTOM_FIELD_MAP | 1 | 21 | 1 (0)| 00:00:01 | |* 61 | TABLE ACCESS BY INDEX ROWID | PRODUCT_ORDER | 1 | 51 | 2 (0)| 00:00:01 | |* 62 | INDEX RANGE SCAN | PRODUCT_ORDER_KEY_INDX | 1 | | 1 (0)| 00:00:01 | |* 63 | TABLE ACCESS BY INDEX ROWID | PBVORG | 1 | 28 | 1 (0)| 00:00:01 | |* 64 | INDEX UNIQUE SCAN | PBVORG_PK | 1 | | 0 (0)| 00:00:01 | |* 65 | TABLE ACCESS BY INDEX ROWID | ESTIMATE | 1 | 79 | 2 (0)| 00:00:01 | |* 66 | INDEX UNIQUE SCAN | ESTIMATE_PK | 1 | | 1 (0)| 00:00:01 | | 67 | TABLE ACCESS BY INDEX ROWID | CIRQIT_USER | 1 | 31 | 1 (0)| 00:00:01 | |* 68 | INDEX UNIQUE SCAN | CIRQIT_USER_PK | 1 | | 0 (0)| 00:00:01 | |* 69 | INDEX RANGE SCAN | ORDER_STATUS_PK | 5220 | 52200 | 2 (0)| 00:00:01 | -------------------------------------------------------------------------------- ------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 7 - access("H"."ID"="G"."ID") 8 - access("G"."ID"="E"."ID") 9 - access("E"."ID"="F"."ID") 16 - access("C"."PARENT_ORG_ID"=2485) 17 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 18 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2 011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 19 - filter(TRUNC("D"."DISPLAY_ORDER"/100,0)>1) 20 - access("B"."ORG_ID"="D"."ORG_ID" AND "D"."CUSTOM_FIELD_NAME" LIKE 'ACSAcc ount%') filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') 21 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."V ERSION_NBR" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_FIELD_NAME") filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSAccount%') 29 - access("C"."PARENT_ORG_ID"=2485) 30 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 31 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2 011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 32 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."V ERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') 33 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_ FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSActivity%') 42 - access("C"."PARENT_ORG_ID"=2485) 43 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 44 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2 011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 45 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."V ERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') 46 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_ FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSFund%') 55 - access("C"."PARENT_ORG_ID"=2485) 56 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer') 57 - access("B"."ORG_ID"="C"."ORG_ID") filter(TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2 011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 58 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."V ERSION_NBR" AND "A"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') filter("A"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') 59 - access("B"."ORG_ID"="D"."ORG_ID" AND "A"."CUSTOM_FIELD_NAME"="D"."CUSTOM_ FIELD_NAME") filter("D"."CUSTOM_FIELD_NAME" LIKE 'ACSBusPurpose%') 61 - filter("A"."CURRENT_STATUS_NAME"<>'CANC' AND "A"."CURRENT_STATUS_NAME"<>' OREJ') 62 - access("H"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "H"."VERSION_NBR"="A"."V ERSION_NBR") filter("E"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "E"."VERSION_NBR"="A"."V ERSION_NBR" AND "F"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "F"."VERSION_NBR"="A"."V ERSION_NBR" AND "G"."ESTIMATE_NBR"="A"."ESTIMATE_NBR" AND "G"."VERSION_NBR"="A"."V ERSION_NBR") 63 - filter("D"."PARENT_ORG_ID"=2485) 64 - access("A"."CLIENT_ORG_ID"="D"."ORG_ID") 65 - filter("B"."ESTIMATE_CONTACT_USER_ID"='p.dreyer@cancer' AND TRUNC(INTERNAL_FUNCTION("B"."CLIENT_DATE_REQUESTED"))>=TO_DATE(' 2 011-04-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 66 - access("A"."ESTIMATE_NBR"="B"."ESTIMATE_NBR" AND "A"."VERSION_NBR"="B"."V ERSION_NBR") 68 - access("C"."USER_ID"="B"."SPEC_CONTACT_USER_ID") 69 - access("Y"."ORDER_NBR"="A"."ORDER_NBR" AND "Y"."STATUS_NAME"='OACT') CIRQIT@XENON> spool off