STATEMENT_ID TIMESTAMP REMARKS OPERATION OPTIONS OBJECT_NODE OBJECT_OWNER OBJECT_NAME OBJECT_INSTANCE OBJECT_TYPE OPTIMIZER SEARCH_COLUMNS ID PARENT_ID POSITION COST CARDINALITY BYTES OTHER_TAG PARTITION_START PARTITION_STOP PARTITION_ID OTHER DISTRIBUTION ------------------------------ ---------------------- -------------------------------------------------------------------------------- ------------------------------ ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ------------------------------ -------------------------------------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------- -------------------------------------- -------------------------------------- -------------------------------------- -------------------------------------- -------------------------------------- -------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------- ---------- ------------------------------ CC6AAD94 9/2/2008 9:25:30 AM SELECT STATEMENT CHOOSE 0 1977 1977 390699 91032867 CC6AAD94 9/2/2008 9:25:30 AM MERGE JOIN CARTESIAN 1 0 1 1977 390699 91032867 CC6AAD94 9/2/2008 9:25:30 AM MERGE JOIN CARTESIAN 2 1 1 97 235 50995 CC6AAD94 9/2/2008 9:25:30 AM NESTED LOOPS 3 2 1 43 3 645 CC6AAD94 9/2/2008 9:25:30 AM NESTED LOOPS OUTER 4 3 1 20 1 213 CC6AAD94 9/2/2008 9:25:30 AM NESTED LOOPS OUTER 5 4 1 19 1 181 CC6AAD94 9/2/2008 9:25:30 AM NESTED LOOPS OUTER 6 5 1 18 1 149 CC6AAD94 9/2/2008 9:25:30 AM NESTED LOOPS 7 6 1 17 1 117 CC6AAD94 9/2/2008 9:25:30 AM HASH JOIN 8 7 1 11 2 150 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS FULL ADM MEMO_MV 1 9 8 1 2 82 4264 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS BY INDEX ROWID V40USR1 AV_ELEMENT_VIEWS40 3 ANALYZED 10 8 2 8 495 11385 CC6AAD94 9/2/2008 9:25:30 AM INDEX RANGE SCAN V40USR1 AV_ELEMENT_CATEGORY NON-UNIQUE ANALYZED 1 11 10 1 3 1 CC6AAD94 9/2/2008 9:25:30 AM INLIST ITERATOR 12 7 2 CC6AAD94 9/2/2008 9:25:30 AM INDEX RANGE SCAN V40USR1 AV_RESREQ_1_VIEWS40 UNIQUE ANALYZED 3 13 12 1 3 1 42 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS BY INDEX ROWID V40USR1 AV_RESOURCE_VIEWS40 6 ANALYZED 14 6 2 1 1 32 CC6AAD94 9/2/2008 9:25:30 AM INDEX UNIQUE SCAN V40USR1 AV_RESOURCE_1_VIEWS40 UNIQUE ANALYZED 1 15 14 1 1 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS BY INDEX ROWID V40USR1 AV_RESOURCE_VIEWS40 7 ANALYZED 16 5 2 1 1 32 CC6AAD94 9/2/2008 9:25:30 AM INDEX UNIQUE SCAN V40USR1 AV_RESOURCE_1_VIEWS40 UNIQUE ANALYZED 1 17 16 1 1 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS BY INDEX ROWID V40USR1 AV_RESOURCE_VIEWS40 8 ANALYZED 18 4 2 1 1 32 CC6AAD94 9/2/2008 9:25:30 AM INDEX UNIQUE SCAN V40USR1 AV_RESOURCE_1_VIEWS40 UNIQUE ANALYZED 1 19 18 1 1 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS FULL V40USR1 AV_ELEMENT_VIEWS40 2 ANALYZED 20 3 2 23 24 48 CC6AAD94 9/2/2008 9:25:30 AM BUFFER SORT 21 2 2 74 89 178 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS FULL ADM MEMO_ALERTS 5 22 21 1 18 89 178 CC6AAD94 9/2/2008 9:25:30 AM BUFFER SORT 23 1 2 1959 1666 26656 CC6AAD94 9/2/2008 9:25:30 AM TABLE ACCESS FULL V40USR1 AV_RESOURCE_VIEWS40 9 ANALYZED 24 23 1 8 1666 26656