PLAN_TABLE_OUTPUT SQL_ID d4j9xpujhwukx, child number 1 ------------------------------------- SELECT /*+ gather_plan_statistics */ T0.object_id, T0.u7e_fr_s_lastmodifier, T0.u79_fr_s_uocode, T0.u63_fr_s_operationid, T0.u7b_fr_s_customername, T0.u65_fr_n_businessid, T0.u81_fr_s_linkedvisionreference, T0.u70_fr_t_completiondate, T0.u71_fr_t_donedate, T0.doc_state FROM (SELECT * FROM FNOS2_USR.DocVersion WHERE (object_class_id IN (:1, :2, :3) OR object_class_id IS NULL) AND home_id IS NULL) T0 LEFT JOIN (SELECT * FROM FNOS2_USR.Generic WHERE (object_class_id IN (:4) OR object_class_id IS NULL) AND home_id IS NULL) T1 ON T0.u68_refoperationproduct = T1.object_id LEFT JOIN (SELECT * FROM FNOS2_USR.Generic WHERE (object_class_id IN (:5) OR object_class_id IS NULL) AND home_id IS NULL) T2 ON T0.u65_fr_n_businessid = Plan hash value: 3523539223 ------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem | ------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1 | SORT ORDER BY | | 1 | 1 | 0 |00:00:04.19 | 472 | 451 | 1024 | 1024 | | | 2 | NESTED LOOPS | | 1 | 1 | 0 |00:00:04.19 | 472 | 451 | | | | | 3 | NESTED LOOPS OUTER | | 1 | 1 | 0 |00:00:04.19 | 472 | 451 | | | | | 4 | INLIST ITERATOR | | 1 | | 0 |00:00:04.19 | 472 | 451 | | | | |* 5 | TABLE ACCESS BY INDEX ROWID| DOCVERSION | 3 | 1 | 0 |00:00:04.19 | 472 | 451 | | | | |* 6 | INDEX RANGE SCAN | FNR_FR_S_UOCODE_DOC_IDX | 3 | 301 | 462 |00:00:00.08 | 10 | 7 | | | | | 7 | VIEW PUSHED PREDICATE | | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | | |* 8 | TABLE ACCESS BY INDEX ROWID| GENERIC | 0 | 277K| 0 |00:00:00.01 | 0 | 0 | | | | |* 9 | INDEX RANGE SCAN | FNR_FR_N_BUSINESSID_GEN_IDX | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | | |* 10 | TABLE ACCESS BY INDEX ROWID | GENERIC | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | | |* 11 | INDEX UNIQUE SCAN | SYS_C0021128 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | | ------------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 5 - filter(("DOCVERSION"."U68_REFOPERATIONPRODUCT" IS NOT NULL AND "DOCVERSION"."DOC_STATE"<>:6 AND INTERNAL_FUNCTION("DOCVERSION"."U65_FR_N_BUSINESSID") AND (RAWTOHEX("OBJECT_CLASS_ID")=:1 OR RAWTOHEX("OBJECT_CLASS_ID")=:2 OR RAWTOHEX("OBJECT_CLASS_ID")=:3) AND "HOME_ID" IS NULL)) 6 - access(("DOCVERSION"."U79_FR_S_UOCODE"=:13 OR "DOCVERSION"."U79_FR_S_UOCODE"=:14 OR "DOCVERSION"."U79_FR_S_UOCODE"=:15)) 8 - filter((RAWTOHEX("OBJECT_CLASS_ID")=:5 AND "HOME_ID" IS NULL)) 9 - access("GENERIC"."U4F_FR_N_BUSINESSID"="DOCVERSION"."U65_FR_N_BUSINESSID") 10 - filter(("GENERIC"."U2B_FR_N_MO"=TO_NUMBER(:12) AND RAWTOHEX("OBJECT_CLASS_ID")=:4 AND "HOME_ID" IS NULL)) 11 - access("DOCVERSION"."U68_REFOPERATIONPRODUCT"="GENERIC"."OBJECT_ID")