Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop SELECT STATEMENT Optimizer Mode=CHOOSE 1 K 865 SORT UNIQUE 1 K 2 M 865 HASH JOIN OUTER 1 K 2 M 405 HASH JOIN 1 K 500 K 301 HASH JOIN OUTER 61 20 K 298 NESTED LOOPS 61 17 K 248 NESTED LOOPS 3 855 179 HASH JOIN 56 13 K 11 TABLE ACCESS BY INDEX ROWID V40USR1.AV_ELEMENT_VIEWS 40 495 11 K 8 INDEX RANGE SCAN V40USR1.AV_ELEMENT_CATEGORY 495 3 TABLE ACCESS FULL ADM.MEMO_MV 1 K 411 K 2 INLIST ITERATOR INDEX RANGE SCAN V40USR1.AV_RESREQ_1_VIEWS40 1 42 3 TABLE ACCESS FULL V40USR1.AV_ELEMENT_VIEWS40 24 48 23 TABLE ACCESS FULL ADM.DUP_DOCBASE_REQUESTS 4 K 239 K 49 TABLE ACCESS FULL ADM.MEMO_ALERTS 1 K 77 K 2 TABLE ACCESS FULL ADM.DUP_TESTSUB_COAEXP_NRM 1 K 3 M 2 /****************************************************************************************************/ *** SCRIPT START : Session:JAGANNK1@ARTMQA.BDC3PROJ.CO.IN(2) 18-Jun-2008 17:31:04 *** Processing ... select count(*) from AV_ELEMENT Query finished, retrieving results... COUNT(*) -------------------------------------- 16417 1 row(s) retrieved Processing ... select count(*) from ADM.MEMO_MV Query finished, retrieving results... COUNT(*) -------------------------------------- 1914 1 row(s) retrieved Processing ... select count(*) from AV_RESREQ Query finished, retrieving results... COUNT(*) -------------------------------------- 2314643 1 row(s) retrieved Processing ... select count(*) from ADM.DUP_DOCBASE_REQUESTS Query finished, retrieving results... COUNT(*) -------------------------------------- 13031 1 row(s) retrieved Processing ... select count(*) from ADM.DUP_TESTSUB_COAEXP_NRM Query finished, retrieving results... COUNT(*) -------------------------------------- 1615 1 row(s) retrieved *** SCRIPT END : Session:JAGANNK1@ARTMQA.BDC3PROJ.CO.IN(2) 18-Jun-2008 17:31:17 ***