---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 612 | 76 | | 1 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 2 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 3 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 4 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 5 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 6 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 7 | TABLE ACCESS BY INDEX ROWID | COUNTRY_CODE | 1 | 18 | 1 | | 8 | INDEX UNIQUE SCAN | PK_COUNTRY_CODE | 1 | | | | 9 | NESTED LOOPS OUTER | | 1 | 612 | 76 | | 10 | NESTED LOOPS OUTER | | 1 | 596 | 75 | | 11 | NESTED LOOPS OUTER | | 1 | 573 | 74 | | 12 | NESTED LOOPS OUTER | | 1 | 551 | 73 | | 13 | NESTED LOOPS OUTER | | 1 | 532 | 72 | | 14 | NESTED LOOPS OUTER | | 1 | 506 | 71 | | 15 | NESTED LOOPS OUTER | | 1 | 488 | 70 | | 16 | NESTED LOOPS | | 1 | 461 | 69 | | 17 | NESTED LOOPS | | 1 | 439 | 68 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 18 | NESTED LOOPS OUTER | | 1 | 308 | 67 | | 19 | NESTED LOOPS | | 1 | 278 | 66 | | 20 | NESTED LOOPS | | 1 | 228 | 65 | | 21 | HASH JOIN | | 7 | 1386 | 51 | | 22 | TABLE ACCESS FULL | PORTFOLIO | 82 | 6150 | 2 | | 23 | HASH JOIN | | 13015 | 1563K| 48 | | 24 | INDEX FULL SCAN | UK1_FINANCIAL_DIVISION | 6 | 24 | 1 | | 25 | HASH JOIN | | 13015 | 1512K| 46 | | 26 | TABLE ACCESS FULL | DIVISION_EXTENSION | 4 | 36 | 2 | | 27 | TABLE ACCESS FULL | TAXLOTS | 26029 | 2796K| 43 | | 28 | TABLE ACCESS BY INDEX ROWID| POSITIONS | 1 | 30 | 2 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 29 | INDEX RANGE SCAN | POSITIONS_IDX3 | 5 | | 1 | | 30 | TABLE ACCESS BY INDEX ROWID | ACCOUNT | 1 | 50 | 1 | | 31 | INDEX UNIQUE SCAN | PK_ACCOUNT | 1 | | | | 32 | VIEW PUSHED PREDICATE | WIDINVOBJECTIVEINFO | 1 | 30 | 1 | | 33 | NESTED LOOPS | | 55 | 1870 | 3 | | 34 | TABLE ACCESS BY INDEX ROWID| FINANCIAL_DIVISION | 1 | 4 | 1 | | 35 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 36 | TABLE ACCESS BY INDEX ROWID| INVESTMENT_OBJECTIVE | 55 | 1650 | 2 | | 37 | INDEX RANGE SCAN | PK_INVESTMENT_OBJECTIVE | 55 | | 1 | | 38 | TABLE ACCESS BY INDEX ROWID | SEC_MASTER | 1 | 131 | 1 | | 39 | INDEX UNIQUE SCAN | PK_SEC_MASTER | 1 | | | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 40 | TABLE ACCESS BY INDEX ROWID | SEC_MASTER_CLIENT_DATA | 1 | 22 | 1 | | 41 | INDEX UNIQUE SCAN | PK_SEC_MASTER_CLIENT_DATA | 1 | | | | 42 | TABLE ACCESS BY INDEX ROWID | MINOR_INDUSTRY_CODE | 1 | 27 | 1 | | 43 | INDEX UNIQUE SCAN | PK_MINOR_INDUSTRY_CODE | 1 | | | | 44 | TABLE ACCESS BY INDEX ROWID | COUNTRY_CODE | 1 | 18 | 1 | | 45 | INDEX UNIQUE SCAN | PK_COUNTRY_CODE | 1 | | | | 46 | TABLE ACCESS BY INDEX ROWID | MINOR_SECURITY_TYPE | 1 | 26 | 1 | | 47 | INDEX UNIQUE SCAN | PK_MINOR_SECURITY_TYPE | 1 | | | | 48 | TABLE ACCESS BY INDEX ROWID | MAJOR_INDUSTRY_CODE | 1 | 19 | 1 | | 49 | INDEX UNIQUE SCAN | PK_MAJOR_INDUSTRY_CODE | 1 | | | | 50 | TABLE ACCESS BY INDEX ROWID | MAJOR_SECURITY_TYPE | 1 | 22 | 1 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 51 | INDEX UNIQUE SCAN | SYS_C0011877 | 1 | | | | 52 | VIEW PUSHED PREDICATE | WIDPRICINGSOURCEINFO | 1 | 23 | 1 | | 53 | NESTED LOOPS | | 20 | 540 | 3 | | 54 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 55 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 56 | TABLE ACCESS BY INDEX ROWID | PRICING_SOURCE | 20 | 460 | 2 | | 57 | INDEX RANGE SCAN | PK_PRICING_SOURCE | 20 | | 1 | | 58 | VIEW PUSHED PREDICATE | WIDPRICETYPECODEINFO | 1 | 16 | 1 | | 59 | NESTED LOOPS | | 7 | 140 | 3 | | 60 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 61 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 62 | TABLE ACCESS BY INDEX ROWID | PRICE_TYPE_CODE | 7 | 112 | 2 | | 63 | INDEX RANGE SCAN | PK_PRICE_TYPE_CODE | 7 | | 1 | ---------------------------------------------------------------------------------------------------- Note: cpu costing is off, PLAN_TABLE' is old version 71 rows selected. SQL> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | --------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 612 | 256 | | 1 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 2 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 3 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 4 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 5 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 6 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 7 | TABLE ACCESS BY INDEX ROWID | COUNTRY_CODE | 1 | 18 | 1 | | 8 | INDEX UNIQUE SCAN | PK_COUNTRY_CODE | 1 | | | | 9 | NESTED LOOPS OUTER | | 1 | 612 | 256 | | 10 | NESTED LOOPS | | 1 | 582 | 255 | | 11 | NESTED LOOPS OUTER | | 1 | 532 | 254 | | 12 | NESTED LOOPS OUTER | | 1 | 505 | 253 | | 13 | NESTED LOOPS | | 1 | 479 | 252 | | 14 | HASH JOIN OUTER | | 49 | 22001 | 154 | | 15 | HASH JOIN OUTER | | 49 | 21070 | 151 | | 16 | HASH JOIN | | 49 | 19992 | 148 | | 17 | HASH JOIN OUTER | | 49 | 18914 | 143 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 18 | HASH JOIN | | 49 | 18032 | 140 | | 19 | HASH JOIN | | 146 | 34602 | 123 | | 20 | TABLE ACCESS FULL | PORTFOLIO | 1634 | 119K| 3 | | 21 | HASH JOIN OUTER | | 13015 | 2059K| 114 | | 22 | HASH JOIN OUTER | | 13015 | 1766K| 79 | | 23 | HASH JOIN | | 13015 | 1563K| 48 | | 24 | INDEX FULL SCAN | UK1_FINANCIAL_DIVISION | 6 | 24 | 1 | | 25 | HASH JOIN | | 13015 | 1512K| 46 | | 26 | TABLE ACCESS FULL| DIVISION_EXTENSION | 4 | 36 | 2 | | 27 | TABLE ACCESS FULL| TAXLOTS | 26029 | 2796K| 43 | | 28 | VIEW | WIDPRICETYPECODEINFO | 14 | 224 | 4 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 29 | HASH JOIN | | 14 | 280 | 4 | | 30 | INDEX FULL SCAN | UK1_FINANCIAL_DIVISION | 6 | 24 | 1 | | 31 | TABLE ACCESS FULL| PRICE_TYPE_CODE | 7 | 112 | 2 | | 32 | VIEW | WIDPRICINGSOURCEINFO | 40 | 920 | 4 | | 33 | HASH JOIN | | 40 | 1080 | 4 | | 34 | INDEX FULL SCAN | UK1_FINANCIAL_DIVISION | 6 | 24 | 1 | | 35 | TABLE ACCESS FULL | PRICING_SOURCE | 20 | 460 | 2 | | 36 | TABLE ACCESS FULL | SEC_MASTER | 4214 | 539K| 16 | | 37 | TABLE ACCESS FULL | COUNTRY_CODE | 286 | 5148 | 2 | | 38 | TABLE ACCESS FULL | SEC_MASTER_CLIENT_DATA | 4214 | 92708 | 4 | | 39 | TABLE ACCESS FULL | MAJOR_SECURITY_TYPE | 8 | 176 | 2 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 40 | TABLE ACCESS FULL | MAJOR_INDUSTRY_CODE | 50 | 950 | 2 | | 41 | TABLE ACCESS BY INDEX ROWID| POSITIONS | 1 | 30 | 2 | | 42 | INDEX RANGE SCAN | POSITIONS_IDX3 | 5 | | 1 | | 43 | TABLE ACCESS BY INDEX ROWID | MINOR_SECURITY_TYPE | 1 | 26 | 1 | | 44 | INDEX UNIQUE SCAN | PK_MINOR_SECURITY_TYPE | 1 | | | | 45 | TABLE ACCESS BY INDEX ROWID | MINOR_INDUSTRY_CODE | 1 | 27 | 1 | | 46 | INDEX UNIQUE SCAN | PK_MINOR_INDUSTRY_CODE | 1 | | | | 47 | TABLE ACCESS BY INDEX ROWID | ACCOUNT | 1 | 50 | 1 | | 48 | INDEX UNIQUE SCAN | PK_ACCOUNT | 1 | | | | 49 | VIEW PUSHED PREDICATE | WIDINVOBJECTIVEINFO | 1 | 30 | 1 | | 50 | NESTED LOOPS | | 55 | 1870 | 3 | PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- | 51 | TABLE ACCESS BY INDEX ROWID | FINANCIAL_DIVISION | 1 | 4 | 1 | | 52 | INDEX UNIQUE SCAN | PK_FINANCIAL_DIVISION | 1 | | | | 53 | TABLE ACCESS BY INDEX ROWID | INVESTMENT_OBJECTIVE | 55 | 1650 | 2 | | 54 | INDEX RANGE SCAN | PK_INVESTMENT_OBJECTIVE | 55 | | 1 | ---------------------------------------------------------------------------------------------