SQL> / OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- SELECT STATEMENT 79811 SORT 79810 UNION-ALL NESTED LOOPS 27287 NESTED LOOPS 27286 NESTED LOOPS 27285 NESTED LOOPS 27283 NESTED LOOPS 27282 NESTED LOOPS 27281 NESTED LOOPS 27280 HASH JOIN 27248 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- MAT_VIEW ACCESS OBJECTS COUNTRY_MASTER MAT_VIEW 3 HASH JOIN 27244 VIEW OBJECTS 24042 UNION-ALL NESTED LOOPS 22113 VIEW OBJECTS 9760 HASH 9760 VIEW OBJECTS 9455 WINDOW 9455 NESTED LOOPS 9217 NESTED LOOPS 1210 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- HASH JOIN 1118 TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 NESTED LOOPS 1928 VIEW OBJECTS 1494 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- HASH 1494 VIEW OBJECTS 1493 WINDOW 1493 NESTED LOOPS 1492 NESTED LOOPS 1210 HASH JOIN 1118 TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 1524 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 2 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 MAT_VIEW ACCESS OBJECTS PRODUCT MAT_VIEW 1 INDEX OBJECTS PK_PRODUCT INDEX (UNIQUE) 0 MAT_VIEW ACCESS OBJECTS MAINOFFICE MAT_VIEW 1 INDEX OBJECTS PK_MAINOFFICE INDEX (UNIQUE) 0 TABLE ACCESS OBJECTS TRANSACTION_AGENT TABLE 1 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_TRANSACTION_AGENT INDEX (UNIQUE) 0 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 2 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 TABLE ACCESS OBJECTS MSG_HANDLE TABLE 1 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 TABLE ACCESS OBJECTS MSG_HANDLE TABLE 1 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 HASH 26262 NESTED LOOPS 26261 NESTED LOOPS 26261 NESTED LOOPS 26261 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- NESTED LOOPS 26260 NESTED LOOPS 26260 NESTED LOOPS 26259 NESTED LOOPS 26259 HASH JOIN 26227 MAT_VIEW ACCESS OBJECTS COUNTRY_MASTER MAT_VIEW 3 HASH JOIN 26223 VIEW OBJECTS 24042 UNION-ALL NESTED LOOPS 22113 VIEW OBJECTS 9760 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- HASH 9760 VIEW OBJECTS 9455 WINDOW 9455 NESTED LOOPS 9217 NESTED LOOPS 1210 HASH JOIN 1118 TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 NESTED LOOPS 1928 VIEW OBJECTS 1494 HASH 1494 VIEW OBJECTS 1493 WINDOW 1493 NESTED LOOPS 1492 NESTED LOOPS 1210 HASH JOIN 1118 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 1524 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 2 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_PRODUCT INDEX (UNIQUE) 0 MAT_VIEW ACCESS OBJECTS MAINOFFICE MAT_VIEW 1 INDEX OBJECTS PK_MAINOFFICE INDEX (UNIQUE) 0 INDEX OBJECTS PK_TRANSACTION_AGENT INDEX (UNIQUE) 0 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 HASH 26261 NESTED LOOPS 26260 NESTED LOOPS 26260 NESTED LOOPS 26260 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- NESTED LOOPS 26259 NESTED LOOPS 26259 NESTED LOOPS 26258 NESTED LOOPS 26258 HASH JOIN 26226 MAT_VIEW ACCESS OBJECTS COUNTRY_MASTER MAT_VIEW 3 HASH JOIN 26222 VIEW OBJECTS 24042 UNION-ALL NESTED LOOPS 22113 VIEW OBJECTS 9760 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- HASH 9760 VIEW OBJECTS 9455 WINDOW 9455 NESTED LOOPS 9217 NESTED LOOPS 1210 HASH JOIN 1118 TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 NESTED LOOPS 1928 VIEW OBJECTS 1494 HASH 1494 VIEW OBJECTS 1493 WINDOW 1493 NESTED LOOPS 1492 NESTED LOOPS 1210 HASH JOIN 1118 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- TABLE ACCESS OBJECTS CNTL_PARM_TAB TABLE 826 INDEX OBJECTS PK_CNTL_PARM_TAB INDEX (UNIQUE) 26 MAT_VIEW ACCESS OBJECTS SETTLEMENT_ENTITY_CRNCY MAT_VIEW 147 INDEX OBJECTS IDX1_TRANSACTION_COMP_LINK_RPT INDEX 4 TABLE ACCESS OBJECTS TRANSACTION_FXRATE TABLE 5 INDEX OBJECTS PK_TRANSACTION_FXRATE INDEX (UNIQUE) 3 TABLE ACCESS OBJECTS TRANSACTION TABLE 2 INDEX OBJECTS PK_TRANSACTION INDEX (UNIQUE) 1 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 1524 TABLE ACCESS OBJECTS AGENT_HIERARCHY_RPT TABLE 2 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 OPERATION OBJECT_OWNER OBJECT_NAME OBJECT_TYPE COST ------------------------------ --------------- ------------------------------ --------------- ---------- INDEX OBJECTS PK_PRODUCT INDEX (UNIQUE) 0 MAT_VIEW ACCESS OBJECTS MAINOFFICE MAT_VIEW 1 INDEX OBJECTS PK_MAINOFFICE INDEX (UNIQUE) 0 INDEX OBJECTS PK_TRANSACTION_AGENT INDEX (UNIQUE) 0 INDEX OBJECTS PK_AGENT_HIERARCHY_RPT INDEX (UNIQUE) 1 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 INDEX OBJECTS PK_MSG_HANDLE INDEX (UNIQUE) 0 172 rows selected. SQL> spool off