Rows Row Source Operation ------- --------------------------------------------------- 54782 SORT AGGREGATE 3 NESTED LOOPS 192844 TABLE ACCESS BY INDEX ROWID CASE_DTL 192844 INDEX RANGE SCAN CASE_DTL_IND_1 (object id 153424) 3 TABLE ACCESS BY INDEX ROWID CASE_HDR 12 INDEX UNIQUE SCAN PK_CASE_HDR (object id 153426) 12 NESTED LOOPS 1349836 TABLE ACCESS BY INDEX ROWID SYS_CODE 1349836 INDEX RANGE SCAN FK_SYS_CODE (object id 153087) 12 INDEX UNIQUE SCAN PK_CASE_LOCK (object id 153433) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 54782 SORT (AGGREGATE) 3 FILTER 192844 TABLE ACCESS GOAL: ANALYZED(BY INDEX ROWID)OF'CASE_DTL' 192844 NESTED LOOPS 3 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID)OF'CASE_HDR' 12 INDEX GOAL: ANALYZED (RANGE SCAN)OF CASE_HDR_IND_4' (NON-UNIQUE) 12 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'PK_CASE_DTL' (UNIQUE) 1349836 NESTED LOOPS 1349836 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID)OF'SYS_CODE' 12 INDEX GOAL: ANALYZED RANGE SCAN)'FK_SYS_CODE' (NON-UNIQUE) 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_CASE_LOCK'(UNIQUE)