SELECT STATEMENT [CHOOSE] Cost = 14
SORT GROUP BY
NESTED LOOPS OUTER
NESTED LOOPS OUTER
NESTED LOOPS OUTER
NESTED LOOPS OUTER
NESTED LOOPS OUTER
TABLE ACCESS BY INDEX ROWID DOCUMENT [ANALYZED]
INDEX RANGE SCAN DOCUMENT_CASE_IDX [ANALYZED]
INDEX UNIQUE SCAN E_DOC_DECISIONS_PK
VIEW PUSHED PREDICATE TREAD_DOCUMENT_SUBSYSTEM_VW
NESTED LOOPS OUTER
NESTED LOOPS OUTER
TABLE ACCESS BY INDEX ROWID TREAD_DOCUMENT [ANALYZED]
INDEX UNIQUE SCAN TREAD_DOC_DOCID_UK [ANALYZED]
TABLE ACCESS BY INDEX ROWID TREAD_SUBSYSTEM [ANALYZED]
INDEX RANGE SCAN TREAD_SUBSYS_TRDDOCID_IDX [ANALYZED]
INDEX UNIQUE SCAN CD_VALUE_PK [ANALYZED]
INDEX UNIQUE SCAN E_DOC_TAGS_PK
TABLE ACCESS BY INDEX ROWID PROD_DOCUMENT [ANALYZED]
INDEX RANGE SCAN PROD_DOC_DOCID_IDX [ANALYZED]
INDEX RANGE SCAN PROD_DOC_QST_PRDDOCID_FK_IDX [ANALYZED]