Can you please tell me where the explain plan differ from the two below:
For example if there is a FAST
FULL INDEX SCAN against a particular index/table in Explain Plan 2 , but the same table
has a FULL TABLE SCAN performed in Explain Plan 1. Or a RANGE INDEX SCAN. Another thing to
look at would be if the index scan is there but the columns in Access and /or Filter sections are different. Or if
path is the same, but the estimated cost is completely off. Or if significantly
more TempSpace is used in the operation such as SORT or HASH JOIN. Or if it’s
using different query blocks/joining tables in different order.
I got this requirment but im new in performance tunning. Can you please help me out on this.
Explain Plan 1 :
-------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 61430 (100)| |
| 1 | TABLE ACCESS BY INDEX ROWID | TLS_DEAL | 1 | 17 | | 2 (0)| 00:00:01 |
| 2 | INDEX UNIQUE SCAN | XDEAUN01 | 1 | | | 1 (0)| 00:00:01 |
| 3 | TABLE ACCESS BY INDEX ROWID | IQ_WACH_CODETABLE | 1 | 38 | | 3 (0)| 00:00:01 |
| 4 | INDEX RANGE SCAN | XICFNN01 | 1 | | | 2 (0)| 00:00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL2 | 1 | 37 | | 2 (0)| 00:00:01 |
| 6 | INDEX UNIQUE SCAN | XGB2UC01 | 1 | | | 1 (0)| 00:00:01 |
| 7 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_PERSONNEL | 1 | 49 | | 4 (0)| 00:00:01 |
| 8 | INDEX RANGE SCAN | L7X2EDPD | 1 | | | 3 (0)| 00:00:01 |
| 9 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_PERSONNEL | 1 | 49 | | 4 (0)| 00:00:01 |
| 10 | INDEX RANGE SCAN | L7X2EDPD | 1 | | | 3 (0)| 00:00:01 |
| 11 | HASH JOIN | | 24253 | 29M| | 61430 (1)| 00:12:18 |
| 12 | INDEX FAST FULL SCAN | L7X2ED24 | 4156 | 45716 | | 11 (0)| 00:00:01 |
| 13 | NESTED LOOPS | | 20422 | 24M| | 61419 (1)| 00:12:18 |
| 14 | HASH JOIN | | 20422 | 24M| 5896K| 61418 (1)| 00:12:18 |
| 15 | TABLE ACCESS FULL | IQ_EOD_CUSTOMER | 34298 | 5493K| | 1554 (1)| 00:00:19 |
| 16 | HASH JOIN | | 20422 | 20M| | 58535 (1)| 00:11:43 |
| 17 | TABLE ACCESS FULL | IQ_EOD_DEAL | 3499 | 437K| | 92 (0)| 00:00:02 |
| 18 | VIEW | | 24289 | 21M| | 58442 (1)| 00:11:42 |
| 19 | SORT UNIQUE | | 24289 | 17M| 7696K| 58442 (1)| 00:11:42 |
| 20 | UNION-ALL | | | | | | |
| 21 | SORT AGGREGATE | | 1 | 27 | | | |
| 22 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 1 | 27 | | 4 (0)| 00:00:01 |
| 23 | INDEX RANGE SCAN | XACPNN05 | 1 | | | 3 (0)| 00:00:01 |
| 24 | SORT AGGREGATE | | 1 | 29 | | | |
| 25 | FIRST ROW | | 1 | 29 | | 3 (0)| 00:00:01 |
| 26 | INDEX RANGE SCAN (MIN/MAX) | XACPUN05 | 1 | 29 | | 3 (0)| 00:00:01 |
| 27 | HASH JOIN OUTER | | 1281 | 627K| | 8961 (1)| 00:01:48 |
| 28 | HASH JOIN RIGHT OUTER | | 1281 | 554K| | 5901 (1)| 00:01:11 |
| 29 | VIEW | | 52 | 2288 | | 1123 (1)| 00:00:14 |
| 30 | HASH UNIQUE | | 52 | 8164 | | 1123 (1)| 00:00:14 |
| 31 | WINDOW SORT | | 52 | 8164 | | 1123 (1)| 00:00:14 |
| 32 | NESTED LOOPS | | 52 | 8164 | | 1121 (1)| 00:00:14 |
| 33 | NESTED LOOPS | | 52 | 8164 | | 1121 (1)| 00:00:14 |
| 34 | NESTED LOOPS | | 26 | 3198 | | 1043 (1)| 00:00:13 |
| 35 | NESTED LOOPS | | 123 | 14022 | | 1043 (1)| 00:00:13 |
| 36 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 2 (0)| 00:00:01 |
| 37 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 1 (0)| 00:00:01 |
| 38 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 123 | 5904 | | 1043 (1)| 00:00:13 |
| 39 | BITMAP CONVERSION TO ROWIDS | | | | | | |
| 40 | BITMAP AND | | | | | | |
| 41 | BITMAP CONVERSION FROM ROWIDS| | | | | | |
| 42 | SORT ORDER BY | | | | | | |
| 43 | INDEX RANGE SCAN | XACCNN04 | 6414 | | | 19 (0)| 00:00:01 |
| 44 | BITMAP CONVERSION FROM ROWIDS| | | | | | |
| 45 | SORT ORDER BY | | | | | | |
| 46 | INDEX RANGE SCAN | XACCNC05 | 6414 | | | 296 (0)| 00:00:04 |
| 47 | INDEX UNIQUE SCAN | XFEEUN01 | 1 | 9 | | 0 (0)| |
| 48 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 49 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 2 | 68 | | 3 (0)| 00:00:01 |
| 50 | HASH JOIN RIGHT OUTER | | 1281 | 499K| | 4777 (1)| 00:00:58 |
| 51 | VIEW | | 1 | 72 | | 3911 (1)| 00:00:47 |
| 52 | HASH UNIQUE | | 1 | 215 | | 3911 (1)| 00:00:47 |
| 53 | WINDOW SORT | | 1 | 215 | | 3911 (1)| 00:00:47 |
| 54 | NESTED LOOPS | | 1 | 215 | | 3846 (1)| 00:00:47 |
| 55 | NESTED LOOPS | | 2 | 215 | | 3846 (1)| 00:00:47 |
| 56 | NESTED LOOPS | | 1 | 175 | | 3843 (1)| 00:00:47 |
| 57 | NESTED LOOPS | | 1 | 163 | | 3843 (1)| 00:00:47 |
| 58 | NESTED LOOPS | | 1 | 117 | | 3840 (1)| 00:00:47 |
| 59 | NESTED LOOPS | | 1782 | 187K| | 3840 (1)| 00:00:47 |
| 60 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 2 (0)| 00:00:01 |
| 61 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 1 (0)| 00:00:01 |
| 62 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1782 | 74844 | | 3838 (1)| 00:00:47 |
| 63 | INDEX RANGE SCAN | XACCNN04 | 6414 | | | 19 (0)| 00:00:01 |
| 64 | INDEX UNIQUE SCAN | XFEEUN01 | 1 | 9 | | 0 (0)| |
| 65 | SORT AGGREGATE | | 1 | 23 | | | |
| 66 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1 | 23 | | 4 (0)| 00:00:01 |
| 67 | INDEX RANGE SCAN | XACCNN05 | 1 | | | 3 (0)| 00:00:01 |
| 68 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_PORT | 1 | 46 | | 3 (0)| 00:00:01 |
| 69 | INDEX RANGE SCAN | XAPONC02 | 1 | | | 2 (0)| 00:00:01 |
| 70 | INDEX UNIQUE SCAN | XBRNUN05 | 1 | 12 | | 0 (0)| |
| 71 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 72 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 1 | 40 | | 3 (0)| 00:00:01 |
| 73 | VIEW | | 1281 | 409K| | 867 (1)| 00:00:11 |
| 74 | HASH JOIN OUTER | | 1281 | 405K| | 867 (1)| 00:00:11 |
| 75 | HASH JOIN | | 1214 | 316K| | 413 (1)| 00:00:05 |
| 76 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_FEE | 1214 | 133K| | 119 (0)| 00:00:02 |
| 77 | INDEX RANGE SCAN | L7X6ED06 | 1214 | | | 13 (0)| 00:00:01 |
| 78 | TABLE ACCESS FULL | IQ_EOD_FACILITY | 6471 | 973K| | 294 (1)| 00:00:04 |
| 79 | TABLE ACCESS FULL | IQ_EOD_FEE_SHARE | 26244 | 1460K| | 453 (1)| 00:00:06 |
| 80 | VIEW | | 42274 | 2435K| | 3060 (1)| 00:00:37 |
| 81 | HASH UNIQUE | | 42274 | 3674K| 4344K| 3060 (1)| 00:00:37 |
| 82 | WINDOW SORT | | 42274 | 3674K| 4344K| 3060 (1)| 00:00:37 |
| 83 | HASH JOIN | | 42274 | 3674K| | 1329 (1)| 00:00:16 |
| 84 | HASH JOIN | | 34197 | 1569K| | 402 (1)| 00:00:05 |
| 85 | INDEX FAST FULL SCAN | L7X4ED06 | 32528 | 285K| | 43 (0)| 00:00:01 |
| 86 | INDEX RANGE SCAN | XACPUN05 | 45744 | 1697K| | 358 (0)| 00:00:05 |
| 87 | INDEX FAST FULL SCAN | XAPPNN04 | 396K| 15M| | 926 (1)| 00:00:12 |
| 88 | TABLE ACCESS BY INDEX ROWID | TLS_OBJ_EXT_ATR | 1 | 67 | | 5 (0)| 00:00:01 |
| 89 | INDEX RANGE SCAN | L7XZ2OEA | 1 | | | 4 (0)| 00:00:01 |
| 90 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL2 | 1 | 35 | | 2 (0)| 00:00:01 |
| 91 | INDEX UNIQUE SCAN | XGB2UC01 | 1 | | | 1 (0)| 00:00:01 |
| 92 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL2 | 1 | 14 | | 2 (0)| 00:00:01 |
| 93 | INDEX UNIQUE SCAN | XGB2UC01 | 1 | | | 1 (0)| 00:00:01 |
| 94 | SORT AGGREGATE | | 1 | 20 | | | |
| 95 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 2 | 40 | | 4 (0)| 00:00:01 |
| 96 | INDEX RANGE SCAN | XACCNC03 | 2 | | | 3 (0)| 00:00:01 |
| 97 | SORT AGGREGATE | | 1 | 47 | | | |
| 98 | NESTED LOOPS | | 2 | 94 | | 9 (0)| 00:00:01 |
| 99 | INDEX RANGE SCAN | XACCNN05 | 2 | 48 | | 3 (0)| 00:00:01 |
| 100 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 1 | 23 | | 3 (0)| 00:00:01 |
| 101 | INDEX RANGE SCAN | XACPNN08 | 1 | | | 2 (0)| 00:00:01 |
| 102 | NESTED LOOPS OUTER | | 2 | 932 | | 1980 (1)| 00:00:24 |
| 103 | NESTED LOOPS OUTER | | 2 | 846 | | 1948 (1)| 00:00:24 |
| 104 | NESTED LOOPS OUTER | | 2 | 772 | | 1928 (1)| 00:00:24 |
| 105 | VIEW | | 2 | 662 | | 1908 (1)| 00:00:23 |
| 106 | NESTED LOOPS OUTER | | 2 | 654 | | 1908 (1)| 00:00:23 |
| 107 | NESTED LOOPS | | 2 | 546 | | 1888 (1)| 00:00:23 |
| 108 | NESTED LOOPS | | 2 | 496 | | 1884 (1)| 00:00:23 |
| 109 | NESTED LOOPS | | 2 | 214 | | 1883 (1)| 00:00:23 |
| 110 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL3 | 1 | 18 | | 3 (0)| 00:00:01 |
| 111 | INDEX RANGE SCAN | XGB3UC01 | 1 | | | 2 (0)| 00:00:01 |
| 112 | TABLE ACCESS BY INDEX ROWID | TLS_OUTSTANDING | 2 | 178 | | 1880 (1)| 00:00:23 |
| 113 | INDEX RANGE SCAN | XOSTNN20 | 1982 | | | 280 (1)| 00:00:04 |
| 114 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_FACILITY | 1 | 141 | | 1 (0)| 00:00:01 |
| 115 | INDEX UNIQUE SCAN | L7X1ED02 | 1 | | | 0 (0)| |
| 116 | TABLE ACCESS BY INDEX ROWID | TLS_OST_RATES | 1 | 25 | | 2 (0)| 00:00:01 |
| 117 | INDEX UNIQUE SCAN | XORTUC02 | 1 | | | 1 (0)| 00:00:01 |
| 118 | VIEW PUSHED PREDICATE | | 1 | 54 | | 10 (20)| 00:00:01 |
| 119 | SORT GROUP BY | | 1 | 63 | | 10 (20)| 00:00:01 |
| 120 | VIEW | VM_NWVW_2 | 1 | 63 | | 9 (12)| 00:00:01 |
| 121 | SORT GROUP BY | | 1 | 139 | | 9 (12)| 00:00:01 |
| 122 | NESTED LOOPS | | 1 | 139 | | 8 (0)| 00:00:01 |
| 123 | NESTED LOOPS | | 1 | 115 | | 8 (0)| 00:00:01 |
| 124 | NESTED LOOPS | | 1 | 51 | | 5 (0)| 00:00:01 |
| 125 | TABLE ACCESS BY INDEX ROWID | TLS_OUTSTANDING | 1 | 27 | | 3 (0)| 00:00:01 |
| 126 | INDEX UNIQUE SCAN | XOSTUN01 | 1 | | | 2 (0)| 00:00:01 |
| 127 | INDEX RANGE SCAN | XOTRNN05 | 1 | 24 | | 2 (0)| 00:00:01 |
| 128 | TABLE ACCESS BY INDEX ROWID | TLS_OST_TR_POR_SHR | 1 | 64 | | 3 (0)| 00:00:01 |
| 129 | INDEX RANGE SCAN | XOTFNC02 | 1 | | | 2 (0)| 00:00:01 |
| 130 | INDEX UNIQUE SCAN | XBRNUN05 | 1 | 24 | | 0 (0)| |
| 131 | VIEW PUSHED PREDICATE | | 1 | 55 | | 10 (20)| 00:00:01 |
| 132 | SORT UNIQUE | | 2 | 160 | | 10 (20)| 00:00:01 |
| 133 | WINDOW SORT | | 2 | 160 | | 10 (20)| 00:00:01 |
| 134 | NESTED LOOPS | | 2 | 160 | | 8 (0)| 00:00:01 |
| 135 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 2 | 76 | | 4 (0)| 00:00:01 |
| 136 | INDEX RANGE SCAN | XACPNN05 | 2 | | | 3 (0)| 00:00:01 |
| 137 | INDEX RANGE SCAN | XAPPNN04 | 1 | 42 | | 2 (0)| 00:00:01 |
| 138 | VIEW PUSHED PREDICATE | | 1 | 37 | | 10 (10)| 00:00:01 |
| 139 | SORT UNIQUE | | 1 | 157 | | 10 (10)| 00:00:01 |
| 140 | WINDOW BUFFER | | 1 | 157 | | 10 (10)| 00:00:01 |
| 141 | NESTED LOOPS | | 1 | 157 | | 9 (0)| 00:00:01 |
| 142 | NESTED LOOPS | | 2 | 157 | | 9 (0)| 00:00:01 |
| 143 | NESTED LOOPS | | 1 | 123 | | 6 (0)| 00:00:01 |
| 144 | NESTED LOOPS | | 1 | 75 | | 3 (0)| 00:00:01 |
| 145 | INDEX UNIQUE SCAN | XOSTUN01 | 1 | 9 | | 2 (0)| 00:00:01 |
| 146 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 1 (0)| 00:00:01 |
| 147 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 0 (0)| |
| 148 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1 | 48 | | 3 (0)| 00:00:01 |
| 149 | INDEX RANGE SCAN | XACCNC03 | 1 | | | 2 (0)| 00:00:01 |
| 150 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 151 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 2 | 68 | | 3 (0)| 00:00:01 |
| 152 | VIEW PUSHED PREDICATE | | 1 | 43 | | 16 (7)| 00:00:01 |
| 153 | SORT UNIQUE | | 1 | 217 | | 16 (7)| 00:00:01 |
| 154 | WINDOW BUFFER | | 1 | 217 | | 16 (7)| 00:00:01 |
| 155 | FILTER | | | | | | |
| 156 | NESTED LOOPS | | 1 | 217 | | 11 (0)| 00:00:01 |
| 157 | NESTED LOOPS | | 2 | 217 | | 11 (0)| 00:00:01 |
| 158 | NESTED LOOPS | | 1 | 175 | | 8 (0)| 00:00:01 |
| 159 | NESTED LOOPS | | 1 | 129 | | 5 (0)| 00:00:01 |
| 160 | NESTED LOOPS | | 1 | 87 | | 2 (0)| 00:00:01 |
| 161 | NESTED LOOPS | | 1 | 78 | | 1 (0)| 00:00:01 |
| 162 | INDEX UNIQUE SCAN | XBRNUN05 | 1 | 12 | | 0 (0)| |
| 163 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 1 (0)| 00:00:01 |
| 164 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 0 (0)| |
| 165 | INDEX UNIQUE SCAN | XOSTUN01 | 1 | 9 | | 1 (0)| 00:00:01 |
| 166 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1 | 42 | | 3 (0)| 00:00:01 |
| 167 | INDEX RANGE SCAN | XACCNC03 | 1 | | | 2 (0)| 00:00:01 |
| 168 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_PORT | 1 | 46 | | 3 (0)| 00:00:01 |
| 169 | INDEX RANGE SCAN | XAPONN06 | 1 | | | 2 (0)| 00:00:01 |
| 170 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 171 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 1 | 42 | | 3 (0)| 00:00:01 |
| 172 | SORT AGGREGATE | | 1 | 23 | | | |
| 173 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 2 | 46 | | 4 (0)| 00:00:01 |
| 174 | INDEX RANGE SCAN | XACCNC03 | 2 | | | 3 (0)| 00:00:01 |
| 175 | TABLE ACCESS BY INDEX ROWID | TLS_OBJ_EXT_ATR | 1 | 67 | | 5 (0)| 00:00:01 |
| 176 | INDEX RANGE SCAN | L7XZ2OEA | 1 | | | 4 (0)| 00:00:01 |
| 177 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL2 | 1 | 35 | | 2 (0)| 00:00:01 |
| 178 | INDEX UNIQUE SCAN | XGB2UC01 | 1 | | | 1 (0)| 00:00:01 |
| 179 | TABLE ACCESS BY INDEX ROWID | TLS_FAM_GLOBAL2 | 1 | 14 | | 2 (0)| 00:00:01 |
| 180 | INDEX UNIQUE SCAN | XGB2UC01 | 1 | | | 1 (0)| 00:00:01 |
| 181 | SORT AGGREGATE | | 1 | 20 | | | |
| 182 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1 | 20 | | 4 (0)| 00:00:01 |
| 183 | INDEX RANGE SCAN | XACCNN05 | 1 | | | 3 (0)| 00:00:01 |
| 184 | SORT AGGREGATE | | 1 | 47 | | | |
| 185 | NESTED LOOPS | | 1 | 47 | | 6 (0)| 00:00:01 |
| 186 | INDEX RANGE SCAN | XACCNN05 | 1 | 24 | | 3 (0)| 00:00:01 |
| 187 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 1 | 23 | | 3 (0)| 00:00:01 |
| 188 | INDEX RANGE SCAN | XACPNN08 | 1 | | | 2 (0)| 00:00:01 |
| 189 | HASH JOIN RIGHT OUTER | | 10674 | 5243K| | 35512 (1)| 00:07:07 |
| 190 | VIEW | | 142 | 6248 | | 3089 (1)| 00:00:38 |
| 191 | HASH UNIQUE | | 142 | 22294 | | 3089 (1)| 00:00:38 |
| 192 | WINDOW SORT | | 142 | 22294 | | 3089 (1)| 00:00:38 |
| 193 | NESTED LOOPS | | 142 | 22294 | | 3087 (1)| 00:00:38 |
| 194 | NESTED LOOPS | | 142 | 22294 | | 3087 (1)| 00:00:38 |
| 195 | NESTED LOOPS | | 69 | 8487 | | 2880 (1)| 00:00:35 |
| 196 | NESTED LOOPS | | 258 | 29412 | | 2880 (1)| 00:00:35 |
| 197 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 2 (0)| 00:00:01 |
| 198 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 1 (0)| 00:00:01 |
| 199 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 258 | 12384 | | 2880 (1)| 00:00:35 |
| 200 | BITMAP CONVERSION TO ROWIDS | | | | | | |
| 201 | BITMAP AND | | | | | | |
| 202 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
| 203 | SORT ORDER BY | | | | | | |
| 204 | INDEX RANGE SCAN | XACCNN04 | 6414 | | | 19 (0)| 00:00:01 |
| 205 | BITMAP CONVERSION FROM ROWIDS | | | | | | |
| 206 | SORT ORDER BY | | | | 1632K| | |
| 207 | INDEX RANGE SCAN | XACCNC05 | 6414 | | | 618 (1)| 00:00:08 |
| 208 | INDEX UNIQUE SCAN | XIBCUC01 | 1 | 9 | | 0 (0)| |
| 209 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 210 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 2 | 68 | | 3 (0)| 00:00:01 |
| 211 | HASH JOIN RIGHT OUTER | | 10674 | 4784K| | 32423 (1)| 00:06:30 |
| 212 | VIEW | | 1 | 72 | | 3867 (1)| 00:00:47 |
| 213 | HASH UNIQUE | | 1 | 217 | | 3867 (1)| 00:00:47 |
| 214 | WINDOW SORT | | 1 | 217 | | 3867 (1)| 00:00:47 |
| 215 | NESTED LOOPS | | 1 | 217 | | 3846 (1)| 00:00:47 |
| 216 | NESTED LOOPS | | 2 | 217 | | 3846 (1)| 00:00:47 |
| 217 | NESTED LOOPS | | 1 | 175 | | 3843 (1)| 00:00:47 |
| 218 | NESTED LOOPS | | 1 | 163 | | 3843 (1)| 00:00:47 |
| 219 | NESTED LOOPS | | 1 | 117 | | 3840 (1)| 00:00:47 |
| 220 | NESTED LOOPS | | 1782 | 187K| | 3840 (1)| 00:00:47 |
| 221 | TABLE ACCESS BY INDEX ROWID | TLS_ENVIRONMENT | 1 | 66 | | 2 (0)| 00:00:01 |
| 222 | INDEX UNIQUE SCAN | XENVUC01 | 1 | | | 1 (0)| 00:00:01 |
| 223 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1782 | 74844 | | 3838 (1)| 00:00:47 |
| 224 | INDEX RANGE SCAN | XACCNN04 | 6414 | | | 19 (0)| 00:00:01 |
| 225 | INDEX UNIQUE SCAN | XIBCUC01 | 1 | 9 | | 0 (0)| |
| 226 | SORT AGGREGATE | | 1 | 23 | | | |
| 227 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 1 | 23 | | 4 (0)| 00:00:01 |
| 228 | INDEX RANGE SCAN | XACCNN05 | 1 | | | 3 (0)| 00:00:01 |
| 229 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_PORT | 1 | 46 | | 3 (0)| 00:00:01 |
| 230 | INDEX RANGE SCAN | XAPONC02 | 1 | | | 2 (0)| 00:00:01 |
| 231 | INDEX UNIQUE SCAN | XBRNUN05 | 1 | 12 | | 0 (0)| |
| 232 | INDEX RANGE SCAN | XALINC02 | 2 | | | 2 (0)| 00:00:01 |
| 233 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_LINE_ITEM | 1 | 42 | | 3 (0)| 00:00:01 |
| 234 | HASH JOIN OUTER | | 10674 | 4034K| 3552K| 28556 (1)| 00:05:43 |
| 235 | VIEW | | 10674 | 3419K| | 18012 (1)| 00:03:37 |
| 236 | HASH JOIN | | 10674 | 3168K| | 18012 (1)| 00:03:37 |
| 237 | TABLE ACCESS FULL | IQ_EOD_FACILITY | 6471 | 891K| | 294 (1)| 00:00:04 |
| 238 | HASH JOIN | | 11919 | 1897K| | 17718 (1)| 00:03:33 |
| 239 | HASH JOIN | | 11919 | 1606K| | 16077 (1)| 00:03:13 |
| 240 | INDEX FAST FULL SCAN | XIBCNN05 | 25172 | 442K| | 32 (0)| 00:00:01 |
| 241 | HASH JOIN OUTER | | 11895 | 1393K| | 16045 (1)| 00:03:13 |
| 242 | TABLE ACCESS FULL | TLS_OUTSTANDING | 11895 | 964K| | 3615 (1)| 00:00:44 |
| 243 | VIEW | | 29979 | 1083K| | 12429 (1)| 00:02:30 |
| 244 | HASH GROUP BY | | 29979 | 1639K| | 12429 (1)| 00:02:30 |
| 245 | VIEW | VM_NWVW_3 | 29979 | 1639K| | 12429 (1)| 00:02:30 |
| 246 | HASH GROUP BY | | 29979 | 4069K| 4536K| 12429 (1)| 00:02:30 |
| 247 | NESTED LOOPS | | 29979 | 4069K| | 11502 (1)| 00:02:19 |
| 248 | HASH JOIN | | 29979 | 3366K| 3776K| 11501 (1)| 00:02:19 |
| 249 | HASH JOIN | | 61266 | 3051K| | 4124 (1)| 00:00:50 |
| 250 | INDEX RANGE SCAN | XOSTNN22 | 11895 | 313K| | 56 (0)| 00:00:01 |
| 251 | INDEX FAST FULL SCAN | XOTRNN04 | 1638K| 37M| | 4063 (1)| 00:00:49 |
| 252 | TABLE ACCESS FULL | TLS_OST_TR_POR_SHR | 799K| 48M| | 4315 (1)| 00:00:52 |
| 253 | INDEX UNIQUE SCAN | XBRNUN05 | 1 | 24 | | 0 (0)| |
| 254 | TABLE ACCESS FULL | TLS_OST_RATES | 320K| 7816K| | 1640 (1)| 00:00:20 |
| 255 | VIEW | | 88884 | 5121K| | 10072 (1)| 00:02:01 |
| 256 | HASH UNIQUE | | 88884 | 9027K| 10M| 10072 (1)| 00:02:01 |
| 257 | WINDOW SORT | | 88884 | 9027K| 10M| 10072 (1)| 00:02:01 |
| 258 | HASH JOIN | | 88884 | 9027K| 8464K| 5866 (1)| 00:01:11 |
| 259 | HASH JOIN | | 117K| 7089K| 3632K| 3514 (1)| 00:00:43 |
| 260 | INDEX RANGE SCAN | XACCNC05 | 103K| 2419K| | 619 (1)| 00:00:08 |
| 261 | INDEX FAST FULL SCAN | XACPUN05 | 522K| 18M| | 1481 (1)| 00:00:18 |
| 262 | INDEX FAST FULL SCAN | XAPPNN04 | 396K| 15M| | 926 (1)| 00:00:12 |
| 263 | SORT AGGREGATE | | 1 | 19 | | | |
| 264 | TABLE ACCESS BY INDEX ROWID | TLS_AMORT_PERIOD | 2 | 38 | | 4 (0)| 00:00:01 |
| 265 | INDEX RANGE SCAN | XAMCNN03 | 2 | | | 2 (0)| 00:00:01 |
| 266 | SORT AGGREGATE | | 1 | 47 | | | |
| 267 | NESTED LOOPS | | 2 | 94 | | 8 (0)| 00:00:01 |
| 268 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 2 | 64 | | 4 (0)| 00:00:01 |
| 269 | INDEX RANGE SCAN | XACPNC02 | 2 | | | 3 (0)| 00:00:01 |
| 270 | INDEX RANGE SCAN | XAPPNN04 | 1 | 15 | | 2 (0)| 00:00:01 |
| 271 | SORT AGGREGATE | | 1 | 44 | | | |
| 272 | NESTED LOOPS | | 2 | 88 | | 7 (0)| 00:00:01 |
| 273 | INDEX RANGE SCAN | XACPNN11 | 2 | 48 | | 3 (0)| 00:00:01 |
| 274 | INDEX RANGE SCAN | XAPPNN04 | 1 | 20 | | 2 (0)| 00:00:01 |
| 275 | SORT AGGREGATE | | 1 | 47 | | | |
| 276 | NESTED LOOPS | | 2 | 94 | | 8 (0)| 00:00:01 |
| 277 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 2 | 64 | | 4 (0)| 00:00:01 |
| 278 | INDEX RANGE SCAN | XACPNC02 | 2 | | | 3 (0)| 00:00:01 |
| 279 | INDEX RANGE SCAN | XAPPNN04 | 1 | 15 | | 2 (0)| 00:00:01 |
| 280 | SORT AGGREGATE | | 1 | 12 | | | |
| 281 | TABLE ACCESS BY INDEX ROWID | TLS_AMORT_PERIOD | 1 | 12 | | 4 (0)| 00:00:01 |
| 282 | INDEX RANGE SCAN | XAMCNN03 | 2 | | | 2 (0)| 00:00:01 |
| 283 | HASH JOIN RIGHT OUTER | | 1280 | 470K| | 2232 (1)| 00:00:27 |
| 284 | VIEW | | 2077 | 91388 | | 1562 (1)| 00:00:19 |
| 285 | HASH UNIQUE | | 2077 | 83080 | | 1562 (1)| 00:00:19 |
| 286 | WINDOW SORT | | 2077 | 83080 | | 1562 (1)| 00:00:19 |
| 287 | HASH JOIN | | 2077 | 83080 | | 1560 (1)| 00:00:19 |
| 288 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 2077 | 64387 | | 1516 (0)| 00:00:19 |
| 289 | INDEX RANGE SCAN | XACCNC05 | 2077 | | | 15 (0)| 00:00:01 |
| 290 | INDEX FAST FULL SCAN | L7X4ED06 | 32528 | 285K| | 43 (0)| 00:00:01 |
| 291 | HASH JOIN RIGHT OUTER | | 1278 | 414K| | 670 (1)| 00:00:09 |
| 292 | VIEW | | 1 | 44 | | 240 (2)| 00:00:03 |
| 293 | NESTED LOOPS | | 1 | 140 | | 240 (2)| 00:00:03 |
| 294 | NESTED LOOPS | | 1 | 131 | | 234 (2)| 00:00:03 |
| 295 | NESTED LOOPS | | 1 | 122 | | 233 (2)| 00:00:03 |
| 296 | HASH JOIN | | 5 | 285 | | 213 (2)| 00:00:03 |
| 297 | TABLE ACCESS FULL | TLS_AMORT_PERIOD | 13202 | 335K| | 105 (0)| 00:00:02 |
| 298 | VIEW | | 13202 | 399K| | 108 (3)| 00:00:02 |
| 299 | HASH UNIQUE | | 13202 | 348K| | 108 (3)| 00:00:02 |
| 300 | WINDOW SORT | | 13202 | 348K| | 108 (3)| 00:00:02 |
| 301 | TABLE ACCESS FULL | TLS_AMORT_PERIOD | 13202 | 348K| | 105 (0)| 00:00:02 |
| 302 | TABLE ACCESS BY INDEX ROWID | TLS_GL_ENTRY | 1 | 65 | | 4 (0)| 00:00:01 |
| 303 | INDEX RANGE SCAN | XGLENN20 | 1 | | | 3 (0)| 00:00:01 |
| 304 | INDEX RANGE SCAN | L7X1ED06 | 1 | 9 | | 1 (0)| 00:00:01 |
| 305 | VIEW PUSHED PREDICATE | VW_SQ_1 | 1 | 9 | | 6 (0)| 00:00:01 |
| 306 | FILTER | | | | | | |
| 307 | SORT AGGREGATE | | 1 | 22 | | | |
| 308 | TABLE ACCESS BY INDEX ROWID | TLS_GL_ENTRY | 40 | 880 | | 6 (0)| 00:00:01 |
| 309 | INDEX RANGE SCAN | L7XF2GLE | 3 | | | 4 (0)| 00:00:01 |
| 310 | HASH JOIN | | 1278 | 359K| | 430 (1)| 00:00:06 |
| 311 | INDEX FAST FULL SCAN | L7X2ED24 | 4156 | 83120 | | 11 (0)| 00:00:01 |
| 312 | HASH JOIN | | 1280 | 335K| | 419 (1)| 00:00:06 |
| 313 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_FEE | 1280 | 146K| | 125 (0)| 00:00:02 |
| 314 | INDEX RANGE SCAN | L7X6ED06 | 1280 | | | 13 (0)| 00:00:01 |
| 315 | TABLE ACCESS FULL | IQ_EOD_FACILITY | 6471 | 954K| | 294 (1)| 00:00:04 |
| 316 | SORT AGGREGATE | | 1 | 23 | | | |
| 317 | TABLE ACCESS BY INDEX ROWID | TLS_ACCR_CYCLE_PMT | 1 | 23 | | 4 (0)| 00:00:01 |
| 318 | INDEX RANGE SCAN | XACPNN08 | 1 | | | 3 (0)| 00:00:01 |
| 319 | HASH JOIN RIGHT OUTER | | 1278 | 460K| | 3773 (1)| 00:00:46 |
| 320 | TABLE ACCESS BY INDEX ROWID | IQ_EOD_FEE_SHARE | 133 | 3192 | | 255 (0)| 00:00:04 |
| 321 | INDEX SKIP SCAN | L7X1ED07 | 133 | | | 161 (0)| 00:00:02 |
| 322 | VIEW | | 1278 | 430K| | 3518 (1)| 00:00:43 |
| 323 | HASH JOIN RIGHT OUTER | | 1278 | 453K| | 3518 (1)| 00:00:43 |
| 324 | VIEW | | 2077 | 91388 | | 1570 (1)| 00:00:19 |
| 325 | HASH GROUP BY | | 2077 | 99K| | 1570 (1)| 00:00:19 |
| 326 | NESTED LOOPS | | 2077 | 99K| | 1569 (1)| 00:00:19 |
| 327 | NESTED LOOPS | | 2077 | 99K| | 1569 (1)| 00:00:19 |
| 328 | TABLE ACCESS BY INDEX ROWID | TLS_ACCRUAL_CYCLE | 2077 | 64387 | | 1516 (0)| 00:00:19 |
| 329 |