---------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | E-Rows | ---------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 1 | WINDOW SORT | | 4736 | | 2 | VIEW | | 4736 | | 3 | WINDOW SORT | | 4736 | | 4 | NESTED LOOPS OUTER | | 4736 | | 5 | HASH JOIN RIGHT OUTER | | 148 | | 6 | TABLE ACCESS BY INDEX ROWID | PRR_MAPPINGS | 1 | | 7 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | | 8 | VIEW | | 148 | | 9 | WINDOW SORT | | 148 | | 10 | WINDOW SORT | | 148 | | 11 | WINDOW SORT | | 148 | | 12 | WINDOW SORT | | 148 | | 13 | HASH JOIN RIGHT ANTI | | 148 | | 14 | TABLE ACCESS BY INDEX ROWID | PRR_MAPPINGS | 1 | | 15 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | | 16 | HASH JOIN OUTER | | 148 | | 17 | HASH JOIN | | 148 | | 18 | NESTED LOOPS | | 1863 | | 19 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | | 20 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | | 21 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 22 | VIEW | | 148 | | 23 | UNION-ALL | | | | 24 | HASH JOIN | | 147 | | 25 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 26 | VIEW | METRICS_V_ALLOC_CONTRIB | 147 | | 27 | UNION-ALL | | | | 28 | FILTER | | | | 29 | VIEW | | 105 | | 30 | UNION-ALL | | | | 31 | FILTER | | | | 32 | HASH JOIN | | 2079 | | 33 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 34 | HASH JOIN | | 2079 | | 35 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | | 36 | FILTER | | | | 37 | HASH JOIN RIGHT OUTER | | 2079 | | 38 | VIEW | METRICS_V_TARGETS | 1 | | 39 | HASH GROUP BY | | 1 | | 40 | INLIST ITERATOR | | | | 41 | TABLE ACCESS BY INDEX ROWID | VEHICLE_METRICS | 1 | | 42 | INDEX RANGE SCAN | VEHICLE_METRICS_IDX2 | 5 | | 43 | NESTED LOOPS | | 21319 | | 44 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | | 45 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | | 46 | VIEW | | 21319 | | 47 | FILTER | | | | 48 | SORT GROUP BY | | 21319 | | 49 | HASH JOIN | | 21319 | | 50 | VIEW | METRICS_V_ELEMENT_CLASS | 2541 | | 51 | SORT UNIQUE | | 2541 | | 52 | UNION-ALL | | | | 53 | CONCATENATION | | | | 54 | FILTER | | | | 55 | HASH JOIN RIGHT OUTER | | 2078 | | 56 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 57 | HASH JOIN | | 2078 | | 58 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 59 | HASH JOIN | | 2078 | | 60 | X ROWID TABLE ACCESS BY INDE | CLASSIFICATIONS | 51 | | 61 | INDEX FULL SCAN | CLASSIFICATIONS_IX2 | 51 | | 62 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 63 | FILTER | | | | 64 | HASH JOIN RIGHT OUTER | | 448 | | 65 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 66 | HASH JOIN | | 448 | | 67 | HASH JOIN | | 448 | | 68 | X ROWID TABLE ACCESS BY INDE | CLASSIFICATIONS | 11 | | 69 | INDEX RANGE SCAN | CLASSIFICATIONS_IX2 | 11 | | 70 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 71 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 72 | CONCATENATION | | | | 73 | FILTER | | | | 74 | HASH JOIN | | 12 | | 75 | HASH JOIN | | 12 | | 76 | HASH JOIN RIGHT SEMI | | 9 | | 77 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 78 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 79 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 80 | ROWID TABLE ACCESS BY INDEX | CLASSIFICATIONS | 51 | | 81 | INDEX FULL SCAN | CLASSIFICATIONS_IX2 | 51 | | 82 | FILTER | | | | 83 | HASH JOIN | | 3 | | 84 | HASH JOIN | | 12 | | 85 | HASH JOIN RIGHT SEMI | | 9 | | 86 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 87 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 88 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 89 | ROWID TABLE ACCESS BY INDEX | CLASSIFICATIONS | 11 | | 90 | INDEX RANGE SCAN | CLASSIFICATIONS_IX2 | 11 | | 91 | VIEW | METRICS_V_POSITIONS | 839 | | 92 | TEMP TABLE TRANSFORMATION | | | | 93 | LOAD AS SELECT | | | | 94 | ID TABLE ACCESS BY INDEX ROW | PERFORMANCE_ELEMENTS | 1 | | 95 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 96 | LOAD AS SELECT | | | | 97 | ID TABLE ACCESS BY INDEX ROW | PERFORMANCE_ELEMENTS | 1 | | 98 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 99 | LOAD AS SELECT | | | | 100 | ID TABLE ACCESS BY INDEX ROW | PERFORMANCE_ELEMENTS | 1 | | 101 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 102 | LOAD AS SELECT | | | | 103 | ID TABLE ACCESS BY INDEX ROW | PERFORMANCE_ELEMENTS | 1 | | 104 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | | 105 | UNION-ALL | | | | 106 | SORT GROUP BY | | 1 | | 107 | MERGE JOIN CARTESIAN | | 47087 | | 108 | MERGE JOIN CARTESIAN | | 47087 | | 109 | MERGE JOIN CARTESIAN | | 47087 | | 110 | MERGE JOIN CARTESIAN | | 47087 | | 111 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 112 | UNION-ALL | | | | 113 | FILTER | | | | 114 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 115 | SORT UNIQUE | | 23543 | | 116 | UNION-ALL | | | | 117 | FILTER | | | | 118 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 119 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 120 | VIEW | | 19038 | | 121 | WINDOW SORT | | 19038 | | 122 | WINDOW SORT | | 19038 | | 123 | WINDOW SORT | | 19038 | | 124 | ION CONCATENAT | | | | 125 | FILTER | | | | 126 | OOPS NESTED L | | 19037 | | 127 | FILTER | | | | 128 | LOOPS OUTER NESTED | | 4505 | | 129 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 130 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | | 131 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 132 | CCESS BY INDEX ROWID TABLE A | POSITIONS | | | 133 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 134 | FILTER | | | | 135 | OOPS NESTED L | | | | 136 | LOOPS NESTED | | 1 | | 137 | FILTER | | | | 138 | D LOOPS OUTER NESTE | | 1 | | 139 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 140 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 141 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 142 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 143 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 1 | | 144 | VIEW | | 23544 | | 145 | UNION-ALL | | | | 146 | NESTED LOOPS | | 1 | | 147 | VIEW | | 1 | | 148 | PUSHED RANK WINDOW BUFFER | | 1 | | 149 | SORT GROUP BY | | 1 | | 150 | FILTER | | | | 151 | FILTER | | | | 152 | HASH JOIN | | 1 | | 153 | ESS BY INDEX ROWID TABLE ACC | VEHICLE_METRICS | 1 | | 154 | NGE SCAN INDEX RA | VEHICLE_METRICS_PK | 1 | | 155 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 156 | QUE SORT UNI | | 224 | | 157 | LL UNION-A | | | | 158 | OIN RIGHT OUTER HASH J | | 204 | | 159 | FULL SCAN INDEX | PK_ELEMENT_AGGREGATES | 158 | | 160 | JOIN HASH | | 204 | | 161 | JOIN HASH | | 204 | | 162 | IST ITERATOR INL | | | | 163 | BLE ACCESS BY INDEX ROWID TA | CLASSIFICATIONS | 5 | | 164 | NDEX RANGE SCAN I | CLASSIFICATIONS_IX1 | 5 | | 165 | EX FAST FULL SCAN IND | PK_CLASSIFICATION_ELEMENTS | 2078 | | 166 | E ACCESS FULL TABL | PERFORMANCE_ELEMENTS | 1863 | | 167 | LOOPS NESTED | | 20 | | 168 | JOIN HASH | | 765 | | 169 | E JOIN CARTESIAN MERG | | 790 | | 170 | IST ITERATOR INL | | | | 171 | BLE ACCESS BY INDEX ROWID TA | CLASSIFICATIONS | 5 | | 172 | NDEX RANGE SCAN I | CLASSIFICATIONS_IX1 | 5 | | 173 | FER SORT BUF | | 158 | | 174 | RT UNIQUE SO | | 158 | | 175 | NDEX FAST FULL SCAN I | PK_ELEMENT_AGGREGATES | 158 | | 176 | E ACCESS FULL TABL | PERFORMANCE_ELEMENTS | 1863 | | 177 | UNIQUE SCAN INDEX | PK_CLASSIFICATION_ELEMENTS | 1 | | 178 | SCAN INDEX RANGE | VEHICLE_METRICS_PK | 1 | | 179 | S BY INDEX ROWID TABLE ACCES | POSITIONS | 1 | | 180 | E SCAN INDEX RANG | POSITIONS_UK | 1 | | 181 | INDEX ROWID TABLE ACCESS BY | PRR_MAPPINGS | 1 | | 182 | AN INDEX RANGE SC | PRR_MAPPINGS_UX1 | 1 | | 183 | FILTER | | | | 184 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 185 | SORT UNIQUE | | 23543 | | 186 | UNION-ALL | | | | 187 | FILTER | | | | 188 | S BY INDEX ROWID TABLE ACCES | POSITIONS | 4505 | | 189 | E SCAN INDEX RANG | POSITIONS_IDX2 | 4505 | | 190 | VIEW | | 19038 | | 191 | WINDOW SORT | | 19038 | | 192 | T WINDOW SOR | | 19038 | | 193 | RT WINDOW SO | | 19038 | | 194 | ATION CONCATEN | | | | 195 | FILTER | | | | 196 | LOOPS NESTED | | 19037 | | 197 | R FILTE | | | | 198 | ED LOOPS OUTER NEST | | 4505 | | 199 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 4505 | | 200 | DEX RANGE SCAN IN | POSITIONS_IDX2 | 4505 | | 201 | EX RANGE SCAN IND | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 202 | ACCESS BY INDEX ROWID TABLE | POSITIONS | | | 203 | X RANGE SCAN INDE | POSITIONS_UK | 1 | | 204 | FILTER | | | | 205 | LOOPS NESTED | | | | 206 | D LOOPS NESTE | | 1 | | 207 | ER FILT | | | | 208 | TED LOOPS OUTER NES | | 1 | | 209 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 4505 | | 210 | NDEX RANGE SCAN I | POSITIONS_IDX2 | 4505 | | 211 | DEX RANGE SCAN IN | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 212 | X UNIQUE SCAN INDE | POSITIONS_PK | 1 | | 213 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | | 214 | BUFFER SORT | | 1 | | 215 | VIEW | | 1 | | 216 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7A_6E3611AA | 1 | | 217 | BUFFER SORT | | 1 | | 218 | VIEW | | 1 | | 219 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7B_6E3611AA | 1 | | 220 | BUFFER SORT | | 1 | | 221 | VIEW | | 1 | | 222 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7C_6E3611AA | 1 | | 223 | BUFFER SORT | | 1 | | 224 | VIEW | | 1 | | 225 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 226 | SORT GROUP BY | | 4 | | 227 | MERGE JOIN CARTESIAN | | 17 | | 228 | MERGE JOIN CARTESIAN | | 17 | | 229 | MERGE JOIN CARTESIAN | | 17 | | 230 | MERGE JOIN CARTESIAN | | 17 | | 231 | HASH JOIN | | 15 | | 232 | VIEW | | 50 | | 233 | RANK WINDOW SORT PUSHED | | 50 | | 234 | NDEX ROWID TABLE ACCESS BY I | VALUATIONS | 50 | | 235 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | | 236 | VIEW | | 15 | | 237 | SORT GROUP BY | | 15 | | 238 | FILTER | | | | 239 | INDEX ROWID TABLE ACCESS BY | VEHICLE_OVERHEADS | 20 | | 240 | N INDEX RANGE SCA | VEHICLE_OVERHEADS_UK | 20 | | 241 | BUFFER SORT | | 1 | | 242 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | | 243 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | | 244 | BUFFER SORT | | 1 | | 245 | VIEW | | 1 | | 246 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7B_6E3611AA | 1 | | 247 | BUFFER SORT | | 1 | | 248 | VIEW | | 1 | | 249 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7C_6E3611AA | 1 | | 250 | BUFFER SORT | | 1 | | 251 | VIEW | | 1 | | 252 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 253 | SORT GROUP BY | | 1 | | 254 | MERGE JOIN CARTESIAN | | 47087 | | 255 | MERGE JOIN CARTESIAN | | 47087 | | 256 | MERGE JOIN CARTESIAN | | 47087 | | 257 | MERGE JOIN CARTESIAN | | 47087 | | 258 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 259 | UNION-ALL | | | | 260 | FILTER | | | | 261 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 262 | SORT UNIQUE | | 23543 | | 263 | UNION-ALL | | | | 264 | FILTER | | | | 265 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 266 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 267 | VIEW | | 19038 | | 268 | WINDOW SORT | | 19038 | | 269 | WINDOW SORT | | 19038 | | 270 | WINDOW SORT | | 19038 | | 271 | ION CONCATENAT | | | | 272 | FILTER | | | | 273 | OOPS NESTED L | | 19037 | | 274 | FILTER | | | | 275 | LOOPS OUTER NESTED | | 4505 | | 276 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 277 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | | 278 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 279 | CCESS BY INDEX ROWID TABLE A | POSITIONS | | | 280 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 281 | FILTER | | | | 282 | OOPS NESTED L | | | | 283 | LOOPS NESTED | | 1 | | 284 | FILTER | | | | 285 | D LOOPS OUTER NESTE | | 1 | | 286 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 287 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 288 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 289 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 290 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 1 | | 291 | VIEW | | 23544 | | 292 | UNION-ALL | | | | 293 | NESTED LOOPS | | 1 | | 294 | VIEW | | 1 | | 295 | PUSHED RANK WINDOW BUFFER | | 1 | | 296 | SORT GROUP BY | | 1 | | 297 | FILTER | | | | 298 | FILTER | | | | 299 | HASH JOIN | | 1 | | 300 | ESS BY INDEX ROWID TABLE ACC | VEHICLE_METRICS | 1 | | 301 | NGE SCAN INDEX RA | VEHICLE_METRICS_PK | 1 | | 302 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 303 | QUE SORT UNI | | 224 | | 304 | LL UNION-A | | | | 305 | OIN RIGHT OUTER HASH J | | 204 | | 306 | FULL SCAN INDEX | PK_ELEMENT_AGGREGATES | 158 | | 307 | JOIN HASH | | 204 | | 308 | JOIN HASH | | 204 | | 309 | IST ITERATOR INL | | | | 310 | BLE ACCESS BY INDEX ROWID TA | CLASSIFICATIONS | 5 | | 311 | NDEX RANGE SCAN I | CLASSIFICATIONS_IX1 | 5 | | 312 | EX FAST FULL SCAN IND | PK_CLASSIFICATION_ELEMENTS | 2078 | | 313 | E ACCESS FULL TABL | PERFORMANCE_ELEMENTS | 1863 | | 314 | LOOPS NESTED | | 20 | | 315 | JOIN HASH | | 765 | | 316 | E JOIN CARTESIAN MERG | | 790 | | 317 | IST ITERATOR INL | | | | 318 | BLE ACCESS BY INDEX ROWID TA | CLASSIFICATIONS | 5 | | 319 | NDEX RANGE SCAN I | CLASSIFICATIONS_IX1 | 5 | | 320 | FER SORT BUF | | 158 | | 321 | RT UNIQUE SO | | 158 | | 322 | NDEX FAST FULL SCAN I | PK_ELEMENT_AGGREGATES | 158 | | 323 | E ACCESS FULL TABL | PERFORMANCE_ELEMENTS | 1863 | | 324 | UNIQUE SCAN INDEX | PK_CLASSIFICATION_ELEMENTS | 1 | | 325 | SCAN INDEX RANGE | VEHICLE_METRICS_PK | 1 | | 326 | S BY INDEX ROWID TABLE ACCES | POSITIONS | 1 | | 327 | E SCAN INDEX RANG | POSITIONS_UK | 1 | | 328 | INDEX ROWID TABLE ACCESS BY | PRR_MAPPINGS | 1 | | 329 | AN INDEX RANGE SC | PRR_MAPPINGS_UX1 | 1 | | 330 | FILTER | | | | 331 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 332 | SORT UNIQUE | | 23543 | | 333 | UNION-ALL | | | | 334 | FILTER | | | | 335 | S BY INDEX ROWID TABLE ACCES | POSITIONS | 4505 | | 336 | E SCAN INDEX RANG | POSITIONS_IDX2 | 4505 | | 337 | VIEW | | 19038 | | 338 | WINDOW SORT | | 19038 | | 339 | T WINDOW SOR | | 19038 | | 340 | RT WINDOW SO | | 19038 | | 341 | ATION CONCATEN | | | | 342 | FILTER | | | | 343 | LOOPS NESTED | | 19037 | | 344 | R FILTE | | | | 345 | ED LOOPS OUTER NEST | | 4505 | | 346 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 4505 | | 347 | DEX RANGE SCAN IN | POSITIONS_IDX2 | 4505 | | 348 | EX RANGE SCAN IND | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 349 | ACCESS BY INDEX ROWID TABLE | POSITIONS | | | 350 | X RANGE SCAN INDE | POSITIONS_UK | 1 | | 351 | FILTER | | | | 352 | LOOPS NESTED | | | | 353 | D LOOPS NESTE | | 1 | | 354 | ER FILT | | | | 355 | TED LOOPS OUTER NES | | 1 | | 356 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 4505 | | 357 | NDEX RANGE SCAN I | POSITIONS_IDX2 | 4505 | | 358 | DEX RANGE SCAN IN | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 359 | X UNIQUE SCAN INDE | POSITIONS_PK | 1 | | 360 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | | 361 | BUFFER SORT | | 1 | | 362 | VIEW | | 1 | | 363 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7A_6E3611AA | 1 | | 364 | BUFFER SORT | | 1 | | 365 | VIEW | | 1 | | 366 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7B_6E3611AA | 1 | | 367 | BUFFER SORT | | 1 | | 368 | VIEW | | 1 | | 369 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7C_6E3611AA | 1 | | 370 | BUFFER SORT | | 1 | | 371 | VIEW | | 1 | | 372 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 373 | SORT GROUP BY | | 1 | | 374 | MERGE JOIN CARTESIAN | | 47087 | | 375 | MERGE JOIN CARTESIAN | | 47087 | | 376 | MERGE JOIN CARTESIAN | | 47087 | | 377 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 378 | UNION-ALL | | | | 379 | FILTER | | | | 380 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 381 | SORT UNIQUE | | 23543 | | 382 | UNION-ALL | | | | 383 | FILTER | | | | 384 | Y INDEX ROWID TABLE ACCESS B | POSITIONS | 4505 | | 385 | CAN INDEX RANGE S | POSITIONS_IDX2 | 4505 | | 386 | VIEW | | 19038 | | 387 | WINDOW SORT | | 19038 | | 388 | WINDOW SORT | | 19038 | | 389 | WINDOW SORT | | 19038 | | 390 | ON CONCATENATI | | | | 391 | FILTER | | | | 392 | OPS NESTED LO | | 19037 | | 393 | FILTER | | | | 394 | LOOPS OUTER NESTED | | 4505 | | 395 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 396 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | | 397 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 398 | CESS BY INDEX ROWID TABLE AC | POSITIONS | | | 399 | ANGE SCAN INDEX R | POSITIONS_UK | 1 | | 400 | FILTER | | | | 401 | OPS NESTED LO | | | | 402 | OOPS NESTED L | | 1 | | 403 | FILTER | | | | 404 | LOOPS OUTER NESTED | | 1 | | 405 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 406 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | | 407 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 408 | NIQUE SCAN INDEX U | POSITIONS_PK | 1 | | 409 | CESS BY INDEX ROWID TABLE AC | POSITIONS | 1 | | 410 | VIEW | | 23544 | | 411 | UNION-ALL | | | | 412 | NESTED LOOPS | | 1 | | 413 | VIEW | | 1 | | 414 | USHED RANK WINDOW BUFFER P | | 1 | | 415 | SORT GROUP BY | | 1 | | 416 | FILTER | | | | 417 | FILTER | | | | 418 | HASH JOIN | | 1 | | 419 | SS BY INDEX ROWID TABLE ACCE | VEHICLE_METRICS | 1 | | 420 | GE SCAN INDEX RAN | VEHICLE_METRICS_PK | 1 | | 421 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 422 | UE SORT UNIQ | | 224 | | 423 | L UNION-AL | | | | 424 | IN RIGHT OUTER HASH JO | | 204 | | 425 | FULL SCAN INDEX | PK_ELEMENT_AGGREGATES | 158 | | 426 | OIN HASH J | | 204 | | 427 | JOIN HASH | | 204 | | 428 | ST ITERATOR INLI | | | | 429 | LE ACCESS BY INDEX ROWID TAB | CLASSIFICATIONS | 5 | | 430 | DEX RANGE SCAN IN | CLASSIFICATIONS_IX1 | 5 | | 431 | X FAST FULL SCAN INDE | PK_CLASSIFICATION_ELEMENTS | 2078 | | 432 | ACCESS FULL TABLE | PERFORMANCE_ELEMENTS | 1863 | | 433 | LOOPS NESTED | | 20 | | 434 | OIN HASH J | | 765 | | 435 | JOIN CARTESIAN MERGE | | 790 | | 436 | ST ITERATOR INLI | | | | 437 | LE ACCESS BY INDEX ROWID TAB | CLASSIFICATIONS | 5 | | 438 | DEX RANGE SCAN IN | CLASSIFICATIONS_IX1 | 5 | | 439 | ER SORT BUFF | | 158 | | 440 | T UNIQUE SOR | | 158 | | 441 | DEX FAST FULL SCAN IN | PK_ELEMENT_AGGREGATES | 158 | | 442 | ACCESS FULL TABLE | PERFORMANCE_ELEMENTS | 1863 | | 443 | UNIQUE SCAN INDEX | PK_CLASSIFICATION_ELEMENTS | 1 | | 444 | SCAN INDEX RANGE | VEHICLE_METRICS_PK | 1 | | 445 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 1 | | 446 | SCAN INDEX RANGE | POSITIONS_UK | 1 | | 447 | INDEX ROWID TABLE ACCESS BY | PRR_MAPPINGS | 1 | | 448 | N INDEX RANGE SCA | PRR_MAPPINGS_UX1 | 1 | | 449 | FILTER | | | | 450 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 451 | SORT UNIQUE | | 23543 | | 452 | UNION-ALL | | | | 453 | FILTER | | | | 454 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 455 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 456 | VIEW | | 19038 | | 457 | WINDOW SORT | | 19038 | | 458 | WINDOW SORT | | 19038 | | 459 | T WINDOW SOR | | 19038 | | 460 | TION CONCATENA | | | | 461 | FILTER | | | | 462 | LOOPS NESTED | | 19037 | | 463 | FILTER | | | | 464 | D LOOPS OUTER NESTE | | 4505 | | 465 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 466 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 467 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 468 | ACCESS BY INDEX ROWID TABLE | POSITIONS | | | 469 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 470 | FILTER | | | | 471 | LOOPS NESTED | | | | 472 | LOOPS NESTED | | 1 | | 473 | R FILTE | | | | 474 | ED LOOPS OUTER NEST | | 1 | | 475 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 4505 | | 476 | DEX RANGE SCAN IN | POSITIONS_IDX2 | 4505 | | 477 | EX RANGE SCAN IND | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 478 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 479 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | | 480 | BUFFER SORT | | 1 | | 481 | VIEW | | 1 | | 482 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7B_6E3611AA | 1 | | 483 | BUFFER SORT | | 1 | | 484 | VIEW | | 1 | | 485 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7C_6E3611AA | 1 | | 486 | BUFFER SORT | | 1 | | 487 | VIEW | | 1 | | 488 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 489 | SORT GROUP BY | | 1 | | 490 | MERGE JOIN CARTESIAN | | 47087 | | 491 | MERGE JOIN CARTESIAN | | 47087 | | 492 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 493 | UNION-ALL | | | | 494 | FILTER | | | | 495 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 496 | SORT UNIQUE | | 23543 | | 497 | UNION-ALL | | | | 498 | FILTER | | | | 499 | INDEX ROWID TABLE ACCESS BY | POSITIONS | 4505 | | 500 | AN INDEX RANGE SC | POSITIONS_IDX2 | 4505 | | 501 | VIEW | | 19038 | | 502 | WINDOW SORT | | 19038 | | 503 | WINDOW SORT | | 19038 | | 504 | WINDOW SORT | | 19038 | | 505 | N CONCATENATIO | | | | 506 | FILTER | | | | 507 | PS NESTED LOO | | 19037 | | 508 | FILTER | | | | 509 | OOPS OUTER NESTED L | | 4505 | | 510 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 4505 | | 511 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | | 512 | ANGE SCAN INDEX R | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 513 | ESS BY INDEX ROWID TABLE ACC | POSITIONS | | | 514 | NGE SCAN INDEX RA | POSITIONS_UK | 1 | | 515 | FILTER | | | | 516 | PS NESTED LOO | | | | 517 | OPS NESTED LO | | 1 | | 518 | FILTER | | | | 519 | LOOPS OUTER NESTED | | 1 | | 520 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 521 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | | 522 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 523 | IQUE SCAN INDEX UN | POSITIONS_PK | 1 | | 524 | ESS BY INDEX ROWID TABLE ACC | POSITIONS | 1 | | 525 | VIEW | | 23544 | | 526 | UNION-ALL | | | | 527 | NESTED LOOPS | | 1 | | 528 | VIEW | | 1 | | 529 | SHED RANK WINDOW BUFFER PU | | 1 | | 530 | SORT GROUP BY | | 1 | | 531 | FILTER | | | | 532 | FILTER | | | | 533 | HASH JOIN | | 1 | | 534 | S BY INDEX ROWID TABLE ACCES | VEHICLE_METRICS | 1 | | 535 | E SCAN INDEX RANG | VEHICLE_METRICS_PK | 1 | | 536 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 537 | E SORT UNIQU | | 224 | | 538 | UNION-ALL | | | | 539 | N RIGHT OUTER HASH JOI | | 204 | | 540 | ULL SCAN INDEX F | PK_ELEMENT_AGGREGATES | 158 | | 541 | IN HASH JO | | 204 | | 542 | OIN HASH J | | 204 | | 543 | T ITERATOR INLIS | | | | 544 | E ACCESS BY INDEX ROWID TABL | CLASSIFICATIONS | 5 | | 545 | EX RANGE SCAN IND | CLASSIFICATIONS_IX1 | 5 | | 546 | FAST FULL SCAN INDEX | PK_CLASSIFICATION_ELEMENTS | 2078 | | 547 | ACCESS FULL TABLE | PERFORMANCE_ELEMENTS | 1863 | | 548 | OOPS NESTED L | | 20 | | 549 | IN HASH JO | | 765 | | 550 | JOIN CARTESIAN MERGE | | 790 | | 551 | T ITERATOR INLIS | | | | 552 | E ACCESS BY INDEX ROWID TABL | CLASSIFICATIONS | 5 | | 553 | EX RANGE SCAN IND | CLASSIFICATIONS_IX1 | 5 | | 554 | R SORT BUFFE | | 158 | | 555 | UNIQUE SORT | | 158 | | 556 | EX FAST FULL SCAN IND | PK_ELEMENT_AGGREGATES | 158 | | 557 | ACCESS FULL TABLE | PERFORMANCE_ELEMENTS | 1863 | | 558 | NIQUE SCAN INDEX U | PK_CLASSIFICATION_ELEMENTS | 1 | | 559 | CAN INDEX RANGE S | VEHICLE_METRICS_PK | 1 | | 560 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 1 | | 561 | SCAN INDEX RANGE | POSITIONS_UK | 1 | | 562 | NDEX ROWID TABLE ACCESS BY I | PRR_MAPPINGS | 1 | | 563 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | | 564 | FILTER | | | | 565 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 566 | SORT UNIQUE | | 23543 | | 567 | UNION-ALL | | | | 568 | FILTER | | | | 569 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 570 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 571 | VIEW | | 19038 | | 572 | WINDOW SORT | | 19038 | | 573 | WINDOW SORT | | 19038 | | 574 | WINDOW SORT | | 19038 | | 575 | ION CONCATENAT | | | | 576 | FILTER | | | | 577 | OOPS NESTED L | | 19037 | | 578 | FILTER | | | | 579 | LOOPS OUTER NESTED | | 4505 | | 580 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | | 581 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | | 582 | RANGE SCAN INDEX | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 583 | CCESS BY INDEX ROWID TABLE A | POSITIONS | | | 584 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 585 | FILTER | | | | 586 | OOPS NESTED L | | | | 587 | LOOPS NESTED | | 1 | | 588 | FILTER | | | | 589 | D LOOPS OUTER NESTE | | 1 | | 590 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 591 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 592 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 593 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 594 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 1 | | 595 | BUFFER SORT | | 1 | | 596 | ROWID TABLE ACCESS BY INDEX | PERFORMANCE_ELEMENTS | 1 | | 597 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 598 | BUFFER SORT | | 1 | | 599 | VIEW | | 1 | | 600 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 601 | SORT GROUP BY | | 194 | | 602 | MERGE JOIN CARTESIAN | | 40908 | | 603 | HASH JOIN RIGHT OUTER | | 40908 | | 604 | TABLE ACCESS FULL | PRR_MAPPINGS | 599 | | 605 | HASH JOIN | | 40908 | <----- | 606 | MERGE JOIN CARTESIAN | | 47087 | <----- | 607 | MERGE JOIN CARTESIAN | | 47087 | <----- | 608 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 609 | UNION-ALL | | | | 610 | FILTER | | | | 611 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 612 | SORT UNIQUE | | 23543 | | 613 | UNION-ALL | | | | 614 | FILTER | | | | 615 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 616 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 617 | VIEW | | 19038 | | 618 | WINDOW SORT | | 19038 | | 619 | WINDOW SORT | | 19038 | | 620 | T WINDOW SOR | | 19038 | | 621 | TION CONCATENA | | | | 622 | FILTER | | | | 623 | LOOPS NESTED | | 19037 | | 624 | FILTER | | | | 625 | D LOOPS OUTER NESTE | | 4505 | | 626 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 627 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 628 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 629 | ACCESS BY INDEX ROWID TABLE | POSITIONS | | | 630 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 631 | FILTER | | | | 632 | LOOPS NESTED | | | | 633 | LOOPS NESTED | | 1 | | 634 | R FILTE | | | | 635 | ED LOOPS OUTER NEST | | 1 | | 636 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 4505 | | 637 | DEX RANGE SCAN IN | POSITIONS_IDX2 | 4505 | | 638 | EX RANGE SCAN IND | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 639 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 640 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | | 641 | VIEW | | 23544 | | 642 | UNION-ALL | | | | 643 | NESTED LOOPS | | 1 | | 644 | VIEW | | 1 | | 645 | PUSHED RANK WINDOW BUFFER | | 1 | | 646 | Y SORT GROUP B | | 1 | | 647 | FILTER | | | | 648 | FILTER | | | | 649 | HASH JOIN | | 1 | | 650 | CESS BY INDEX ROWID TABLE AC | VEHICLE_METRICS | 1 | | 651 | ANGE SCAN INDEX R | VEHICLE_METRICS_PK | 1 | | 652 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 653 | IQUE SORT UN | | 224 | | 654 | ALL UNION- | | | | 655 | JOIN RIGHT OUTER HASH | | 204 | | 656 | X FULL SCAN INDE | PK_ELEMENT_AGGREGATES | 158 | | 657 | JOIN HASH | | 204 | | 658 | H JOIN HAS | | 204 | | 659 | LIST ITERATOR IN | | | | 660 | ABLE ACCESS BY INDEX ROWID T | CLASSIFICATIONS | 5 | | 661 |.INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | | 662 | DEX FAST FULL SCAN IN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 663 | LE ACCESS FULL TAB | PERFORMANCE_ELEMENTS | 1863 | | 664 | D LOOPS NESTE | | 20 | | 665 | JOIN HASH | | 765 | | 666 | GE JOIN CARTESIAN MER | | 790 | | 667 | LIST ITERATOR IN | | | | 668 | ABLE ACCESS BY INDEX ROWID T | CLASSIFICATIONS | 5 | | 669 |.INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | | 670 | FFER SORT BU | | 158 | | 671 | ORT UNIQUE S | | 158 | | 672 |.INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 673 | LE ACCESS FULL TAB | PERFORMANCE_ELEMENTS | 1863 | | 674 | X UNIQUE SCAN INDE | PK_CLASSIFICATION_ELEMENTS | 1 | | 675 | E SCAN INDEX RANG | VEHICLE_METRICS_PK | 1 | | 676 | SS BY INDEX ROWID TABLE ACCE | POSITIONS | 1 | | 677 | GE SCAN INDEX RAN | POSITIONS_UK | 1 | | 678 | Y INDEX ROWID TABLE ACCESS B | PRR_MAPPINGS | 1 | | 679 | CAN INDEX RANGE S | PRR_MAPPINGS_UX1 | 1 | | 680 | FILTER | | | | 681 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 682 | SORT UNIQUE | | 23543 | | 683 | UNION-ALL | | | | 684 | FILTER | | | | 685 | SS BY INDEX ROWID TABLE ACCE | POSITIONS | 4505 | | 686 | GE SCAN INDEX RAN | POSITIONS_IDX2 | 4505 | | 687 | VIEW | | 19038 | | 688 | T WINDOW SOR | | 19038 | | 689 | RT WINDOW SO | | 19038 | | 690 | ORT WINDOW S | | 19038 | | 691 | NATION CONCATE | | | | 692 | FILTER | | | | 693 | D LOOPS NESTE | | 19037 | | 694 | ER FILT | | | | 695 | TED LOOPS OUTER NES | | 4505 | | 696 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 4505 | | 697 | NDEX RANGE SCAN I | POSITIONS_IDX2 | 4505 | | 698 | DEX RANGE SCAN IN | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 699 | E ACCESS BY INDEX ROWID TABL | POSITIONS | | | 700 | EX RANGE SCAN IND | POSITIONS_UK | 1 | | 701 | FILTER | | | | 702 | D LOOPS NESTE | | | | 703 | ED LOOPS NEST | | 1 | | 704 | TER FIL | | | | 705 | STED LOOPS OUTER NE | | 1 | | 706 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 4505 | | 707 |.INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | | 708 | NDEX RANGE SCAN I | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 709 | EX UNIQUE SCAN IND | POSITIONS_PK | 1 | | 710 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | | 711 | BUFFER SORT | | 1 | | 712 | DEX ROWID TABLE ACCESS BY IN | PERFORMANCE_ELEMENTS | 1 | | 713 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 714 | BUFFER SORT | | 1 | | 715 | VIEW | | 1 | | 716 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 717 | TABLE ACCESS FULL | POSITIONS | 7266K| <----- | 718 | BUFFER SORT | | 1 | | 719 | ROWID TABLE ACCESS BY INDEX | PERFORMANCE_ELEMENTS | 1 | | 720 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 721 | SORT GROUP BY | | 637 | | 722 | MERGE JOIN CARTESIAN | | 40908 | | 723 | NESTED LOOPS OUTER | | 40908 | | 724 | HASH JOIN | | 40908 | <----- | 725 | MERGE JOIN CARTESIAN | | 47087 | | 726 | MERGE JOIN CARTESIAN | | 47087 | | 727 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | | 728 | UNION-ALL | | | | 729 | FILTER | | | | 730 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 731 | SORT UNIQUE | | 23543 | | 732 | UNION-ALL | | | | 733 | FILTER | | | | 734 | BY INDEX ROWID TABLE ACCESS | POSITIONS | 4505 | | 735 | SCAN INDEX RANGE | POSITIONS_IDX2 | 4505 | | 736 | VIEW | | 19038 | | 737 | WINDOW SORT | | 19038 | | 738 | WINDOW SORT | | 19038 | | 739 | T WINDOW SOR | | 19038 | | 740 | TION CONCATENA | | | | 741 | FILTER | | | | 742 | LOOPS NESTED | | 19037 | | 743 | FILTER | | | | 744 | D LOOPS OUTER NESTE | | 4505 | | 745 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | | 746 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | | 747 | X RANGE SCAN INDE | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 748 | ACCESS BY INDEX ROWID TABLE | POSITIONS | | | 749 | RANGE SCAN INDEX | POSITIONS_UK | 1 | | 750 | FILTER | | | | 751 | LOOPS NESTED | | | | 752 | LOOPS NESTED | | 1 | | 753 | R FILTE | | | | 754 | ED LOOPS OUTER NEST | | 1 | | 755 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 4505 | | 756 | DEX RANGE SCAN IN | POSITIONS_IDX2 | 4505 | | 757 | EX RANGE SCAN IND | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 758 | UNIQUE SCAN INDEX | POSITIONS_PK | 1 | | 759 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | | 760 | VIEW | | 23544 | | 761 | UNION-ALL | | | | 762 | NESTED LOOPS | | 1 | | 763 | VIEW | | 1 | | 764 | PUSHED RANK WINDOW BUFFER | | 1 | | 765 | Y SORT GROUP B | | 1 | | 766 | FILTER | | | | 767 | FILTER | | | | 768 | HASH JOIN | | 1 | | 769 | CESS BY INDEX ROWID TABLE AC | VEHICLE_METRICS | 1 | | 770 | ANGE SCAN INDEX R | VEHICLE_METRICS_PK | 1 | | 771 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | | 772 | IQUE SORT UN | | 224 | | 773 | ALL UNION- | | | | 774 | JOIN RIGHT OUTER HASH | | 204 | | 775 | X FULL SCAN INDE | PK_ELEMENT_AGGREGATES | 158 | | 776 | JOIN HASH | | 204 | | 777 | H JOIN HAS | | 204 | | 778 | LIST ITERATOR IN | | | | 779 | ABLE ACCESS BY INDEX ROWID T | CLASSIFICATIONS | 5 | | 780 |.INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | | 781 | DEX FAST FULL SCAN IN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 782 | LE ACCESS FULL TAB | PERFORMANCE_ELEMENTS | 1863 | | 783 | D LOOPS NESTE | | 20 | | 784 | JOIN HASH | | 765 | | 785 | GE JOIN CARTESIAN MER | | 790 | | 786 | LIST ITERATOR IN | | | | 787 | ABLE ACCESS BY INDEX ROWID T | CLASSIFICATIONS | 5 | | 788 |.INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | | 789 | FFER SORT BU | | 158 | | 790 | ORT UNIQUE S | | 158 | | 791 |.INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 792 | LE ACCESS FULL TAB | PERFORMANCE_ELEMENTS | 1863 | | 793 | X UNIQUE SCAN INDE | PK_CLASSIFICATION_ELEMENTS | 1 | | 794 | E SCAN INDEX RANG | VEHICLE_METRICS_PK | 1 | | 795 | SS BY INDEX ROWID TABLE ACCE | POSITIONS | 1 | | 796 | GE SCAN INDEX RAN | POSITIONS_UK | 1 | | 797 | Y INDEX ROWID TABLE ACCESS B | PRR_MAPPINGS | 1 | | 798 | CAN INDEX RANGE S | PRR_MAPPINGS_UX1 | 1 | | 799 | FILTER | | | | 800 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | | 801 | SORT UNIQUE | | 23543 | | 802 | UNION-ALL | | | | 803 | FILTER | | | | 804 | SS BY INDEX ROWID TABLE ACCE | POSITIONS | 4505 | | 805 | GE SCAN INDEX RAN | POSITIONS_IDX2 | 4505 | | 806 | VIEW | | 19038 | | 807 | T WINDOW SOR | | 19038 | | 808 | RT WINDOW SO | | 19038 | | 809 | ORT WINDOW S | | 19038 | | 810 | NATION CONCATE | | | | 811 | FILTER | | | | 812 | D LOOPS NESTE | | 19037 | | 813 | ER FILT | | | | 814 | TED LOOPS OUTER NES | | 4505 | | 815 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 4505 | | 816 | NDEX RANGE SCAN I | POSITIONS_IDX2 | 4505 | | 817 | DEX RANGE SCAN IN | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 818 | E ACCESS BY INDEX ROWID TABL | POSITIONS | | | 819 | EX RANGE SCAN IND | POSITIONS_UK | 1 | | 820 | FILTER | | | | 821 | D LOOPS NESTE | | | | 822 | ED LOOPS NEST | | 1 | | 823 | TER FIL | | | | 824 | STED LOOPS OUTER NE | | 1 | | 825 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 4505 | | 826 |.INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | | 827 | NDEX RANGE SCAN I | VEHICLE_RELATIONSHIPS_UK1 | 1 | | 828 | EX UNIQUE SCAN IND | POSITIONS_PK | 1 | | 829 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | | 830 | BUFFER SORT | | 1 | | 831 | DEX ROWID TABLE ACCESS BY IN | PERFORMANCE_ELEMENTS | 1 | | 832 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 833 | BUFFER SORT | | 1 | | 834 | VIEW | | 1 | | 835 | TABLE ACCESS FULL | SYS_TEMP_0FD9D9B7D_6E3611AA | 1 | | 836 | TABLE ACCESS FULL | POSITIONS | 7266K| <----- | 837 | VIEW | | 1 | | 838 | ROWID TABLE ACCESS BY INDEX | PRR_MAPPINGS | 1 | | 839 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | | 840 | BUFFER SORT | | 1 | | 841 | ROWID TABLE ACCESS BY INDEX | PERFORMANCE_ELEMENTS | 1 | | 842 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | | 843 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | | 844 | MERGE JOIN CARTESIAN | | 1 | | 845 | NESTED LOOPS | | | | 846 | NESTED LOOPS | | 1 | | 847 | NESTED LOOPS | | 1 | | 848 | NESTED LOOPS | | 1 | | 849 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | | 850 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | | 851 | VIEW | | 1 | | 852 | WINDOW BUFFER PUSHED RANK | | 1 | | 853 | SORT GROUP BY | | 1 | | 854 | FILTER | | | | 855 | FILTER | | | | 856 | HASH JOIN | | 1 | | 857 | TABLE ACCESS BY INDEX ROWID | VEHICLE_METRICS | 1 | | 858 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | | 859 | VIEW | METRICS_V_ELEMENT_CLASS | 2541 | | 860 | SORT UNIQUE | | 2541 | | 861 | UNION-ALL | | | | 862 | CONCATENATION | | | | 863 | FILTER | | | | 864 | HASH JOIN RIGHT OUTER | | 2078 | | 865 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 866 | HASH JOIN | | 2078 | | 867 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 868 | HASH JOIN | | 2078 | | 869 | EX ROWID TABLE ACCESS BY IND | CLASSIFICATIONS | 51 | | 870 | INDEX FULL SCAN | CLASSIFICATIONS_IX2 | 51 | | 871 | N INDEX FAST FULL SCA | PK_CLASSIFICATION_ELEMENTS | 2078 | | 872 | FILTER | | | | 873 | HASH JOIN RIGHT OUTER | | 448 | | 874 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 875 | HASH JOIN | | 448 | | 876 | HASH JOIN | | 448 | | 877 | EX ROWID TABLE ACCESS BY IND | CLASSIFICATIONS | 11 | | 878 | INDEX RANGE SCAN | CLASSIFICATIONS_IX2 | 11 | | 879 | N INDEX FAST FULL SCA | PK_CLASSIFICATION_ELEMENTS | 2078 | | 880 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 881 | CONCATENATION | | | | 882 | FILTER | | | | 883 | HASH JOIN | | 12 | | 884 | HASH JOIN | | 12 | | 885 | HASH JOIN RIGHT SEMI | | 9 | | 886 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 887 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 888 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 889 | ROWID TABLE ACCESS BY INDEX | CLASSIFICATIONS | 51 | | 890 | INDEX FULL SCAN | CLASSIFICATIONS_IX2 | 51 | | 891 | FILTER | | | | 892 | HASH JOIN | | 3 | | 893 | HASH JOIN | | 12 | | 894 | HASH JOIN RIGHT SEMI | | 9 | | 895 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 896 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 897 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | | 898 | ROWID TABLE ACCESS BY INDEX | CLASSIFICATIONS | 11 | | 899 | INDEX RANGE SCAN | CLASSIFICATIONS_IX2 | 11 | | 900 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | | 901 | TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | | 902 | INDEX RANGE SCAN | POSITIONS_UK | 1 | | 903 | TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 1 | | 904 | INDEX UNIQUE SCAN | CLASSIFICATIONS_PK | 1 | | 905 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_PK | 1 | | 906 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | | 907 | BUFFER SORT | | 1 | | 908 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | | 909 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | | 910 | HASH GROUP BY | | 42 | | 911 | VIEW | | 42 | | 912 | UNION-ALL | | | | 913 | NESTED LOOPS | | 1 | | 914 | NESTED LOOPS | | 1 | | 915 | VIEW | | 50 | | 916 | WINDOW SORT PUSHED RANK | | 50 | | 917 | FILTER | | | | 918 | TABLE ACCESS BY INDEX ROWID | VALUATIONS | 50 | | 919 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | | 920 | TABLE ACCESS BY INDEX ROWID | PRR_MAPPINGS | 1 | | 921 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | | 922 | COLLECTION ITERATOR PICKLER FETCH | GET_METRICS_ALLOC_CONTRIBS_BAS | | | 923 | NESTED LOOPS | | 41 | | 924 | VIEW | | 50 | | 925 | WINDOW SORT PUSHED RANK | | 50 | | 926 | FILTER | | | | 927 | TABLE ACCESS BY INDEX ROWID | VALUATIONS | 50 | | 928 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | | 929 | COLLECTION ITERATOR PICKLER FETCH | GET_METRICS_ALLOC_CONTRIBS_BAS | | | 930 | HASH GROUP BY | | 1 | | 931 | VIEW | | 1 | | 932 | HASH GROUP BY | | 1 | | 933 | FILTER | | | | 934 | NESTED LOOPS | | 1 | | 935 | NESTED LOOPS | | 1 | | 936 | HASH JOIN | | 1 | | 937 | VIEW | METRICS_V_ALLOC_CONTRIB | 147 | | 938 | UNION-ALL | | | | 939 | FILTER | | | | 940 | VIEW | | 105 | | 941 | UNION-ALL | | | | 942 | FILTER | | | | 943 | HASH JOIN | | 2079 | | 944 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | | 945 | HASH JOIN | | 2079 | | 946 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | | 947 | FILTER | | | | 948 | HASH JOIN RIGHT OUTER | | 2079 | | 949 | VIEW | METRICS_V_TARGETS | 1 | | 950 | HASH GROUP BY | | 1 | | 951 | INLIST ITERATOR | | | | 952 | WID TABLE ACCESS BY INDEX RO | VEHICLE_METRICS | 1 | | 953 | INDEX RANGE SCAN | VEHICLE_METRICS_IDX2 | 5 | | 954 | NESTED LOOPS | | 21319 | | 955 | D TABLE ACCESS BY INDEX ROWI | VEHICLES | 1 | | 956 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | | 957 | VIEW | | 21319 | | 958 | FILTER | | | | 959 | SORT GROUP BY | | 21319 | | 960 | HASH JOIN | | 21319 | | 961 | VIEW | METRICS_V_ELEMENT_CLASS | 2541 | | 962 | SORT UNIQUE | | 2541 | | 963 | UNION-ALL | | | | 964 | CONCATENATION | | | | 965 | FILTER | | | | 966 | UTER HASH JOIN RIGHT O | | 2078 | | 967 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 968 | HASH JOIN | | 2078 | | 969 | LL TABLE ACCESS FU | PERFORMANCE_ELEMENTS | 1863 | | 970 | HASH JOIN | | 2078 | | 971 | Y INDEX ROWID TABLE ACCESS B | CLASSIFICATIONS | 51 | | 972 | AN INDEX FULL SC | CLASSIFICATIONS_IX2 | 51 | | 973 | L SCAN INDEX FAST FUL | PK_CLASSIFICATION_ELEMENTS | 2078 | | 974 | FILTER | | | | 975 | UTER HASH JOIN RIGHT O | | 448 | | 976 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | | 977 | HASH JOIN | | 448 | | 978 | HASH JOIN | | 448 | | 979 | Y INDEX ROWID TABLE ACCESS B | CLASSIFICATIONS | 11 | | 980 | CAN INDEX RANGE S | CLASSIFICATIONS_IX2 | 11 | | 981 | L SCAN INDEX FAST FUL | PK_CLASSIFICATION_ELEMENTS | 2078 | | 982 | LL TABLE ACCESS FU | PERFORMANCE_ELEMENTS | 1863 | | 983 | CONCATENATION | | | | 984 | FILTER | | | | 985 | HASH JOIN | | 12 | | 986 | HASH JOIN | | 12 | | 987 | SEMI HASH JOIN RIGHT | | 9 | | 988 | N INDEX FULL SCA | PK_ELEMENT_AGGREGATES | 158 | | 989 | ULL TABLE ACCESS F | PERFORMANCE_ELEMENTS | 1863 | | 990 | SCAN INDEX FAST FULL | PK_CLASSIFICATION_ELEMENTS | 2078 | | 991 | INDEX ROWID TABLE ACCESS BY | CLASSIFICATIONS | 51 | | 992 | INDEX FULL SCAN | CLASSIFICATIONS_IX2 | 51 | | 993 | FILTER | | | | 994 | HASH JOIN | | 3 | | 995 | HASH JOIN | | 12 | | 996 | SEMI HASH JOIN RIGHT | | 9 | | 997 | N INDEX FULL SCA | PK_ELEMENT_AGGREGATES | 158 | | 998 | ULL TABLE ACCESS F | PERFORMANCE_ELEMENTS | 1863 | | 999 | SCAN INDEX FAST FULL | PK_CLASSIFICATION_ELEMENTS | 2078 | |1000 | INDEX ROWID TABLE ACCESS BY | CLASSIFICATIONS | 11 | |1001 | N INDEX RANGE SCA | CLASSIFICATIONS_IX2 | 11 | |1002 | VIEW | METRICS_V_POSITIONS | 839 | |1003 | TION TEMP TABLE TRANSFORMA | | | |1004 | LOAD AS SELECT | | | |1005 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1006 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1007 | LOAD AS SELECT | | | |1008 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1009 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1010 | LOAD AS SELECT | | | |1011 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1012 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1013 | LOAD AS SELECT | | | |1014 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1015 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | |1016 | UNION-ALL | | | |1017 | SORT GROUP BY | | 1 | |1018 | AN MERGE JOIN CARTESI | | 47087 | |1019 | IAN MERGE JOIN CARTES | | 47087 | |1020 | SIAN MERGE JOIN CARTE | | 47087 | |1021 | ESIAN MERGE JOIN CART | | 47087 | |1022 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1023 | UNION-ALL | | | |1024 | FILTER | | | |1025 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1026 | E SORT UNIQU | | 23543 | |1027 | UNION-ALL | | | |1028 | FILTER | | | |1029 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 4505 | |1030 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1031 | VIEW | | 19038 | |1032 | SORT WINDOW | | 19038 | |1033 | SORT WINDOW | | 19038 | |1034 | W SORT WINDO | | 19038 | |1035 | ATENATION CONC | | | |1036 | TER FIL | | | |1037 | STED LOOPS NE | | 19037 | |1038 | ILTER F | | | |1039 |.NESTED LOOPS OUTER | | 4505 | |1040 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1041 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1042 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1043 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | |1044 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | |1045 | TER FIL | | | |1046 | STED LOOPS NE | | | |1047 | ESTED LOOPS N | | 1 | |1048 |.FILTER | | | |1049 |. NESTED LOOPS OUTER | | 1 | |1050 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1051 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1052 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1053 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1054 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | |1055 | VIEW | | 23544 | |1056 | UNION-ALL | | | |1057 | PS NESTED LOO | | 1 | |1058 | VIEW | | 1 | |1059 | UFFER PUSHED RANK WINDOW B | | 1 | |1060 | OUP BY SORT GR | | 1 | |1061 | FILTER | | | |1062 | R FILTE | | | |1063 | JOIN HASH | | 1 | |1064 | LE ACCESS BY INDEX ROWID TAB | VEHICLE_METRICS | 1 | |1065 | DEX RANGE SCAN IN | VEHICLE_METRICS_PK | 1 | |1066 | W VIE | METRICS_V_ELEMENT_CLASS | 224 | |1067 | RT UNIQUE SO | | 224 | |1068 | NION-ALL U | | | |1069 |.HASH JOIN RIGHT OUTER | | 204 | |1070 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1071 |. HASH JOIN | | 204 | |1072 |. HASH JOIN | | 204 | |1073 |. INLIST ITERATOR | | | |1074 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1075 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1076 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1077 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1078 |.NESTED LOOPS | | 20 | |1079 |. HASH JOIN | | 765 | |1080 |. MERGE JOIN CARTESIAN | | 790 | |1081 |. INLIST ITERATOR | | | |1082 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1083 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1084 |. BUFFER SORT | | 158 | |1085 |. SORT UNIQUE | | 158 | |1086 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1087 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1088 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1089 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |1090 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |1091 | X RANGE SCAN INDE | POSITIONS_UK | 1 | |1092 | ESS BY INDEX ROWID TABLE ACC | PRR_MAPPINGS | 1 | |1093 | NGE SCAN INDEX RA | PRR_MAPPINGS_UX1 | 1 | |1094 | FILTER | | | |1095 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1096 | QUE SORT UNI | | 23543 | |1097 | LL UNION-A | | | |1098 | FILTER | | | |1099 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | |1100 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | |1101 | VIEW | | 19038 | |1102 | W SORT WINDO | | 19038 | |1103 | OW SORT WIND | | 19038 | |1104 | DOW SORT WIN | | 19038 | |1105 | NCATENATION CO | | | |1106 | ILTER F | | | |1107 |.NESTED LOOPS | | 19037 | |1108 |. FILTER | | | |1109 |. NESTED LOOPS OUTER | | 4505 | |1110 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1111 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1112 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1113 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1114 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1115 | ILTER F | | | |1116 |.NESTED LOOPS | | | |1117 |. NESTED LOOPS | | 1 | |1118 |. FILTER | | | |1119 |. NESTED LOOPS OUTER | | 1 | |1120 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1121 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1122 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1123 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1124 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1125 | BUFFER SORT | | 1 | |1126 | VIEW | | 1 | |1127 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B82_6E3611AA | 1 | |1128 | BUFFER SORT | | 1 | |1129 | VIEW | | 1 | |1130 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B83_6E3611AA | 1 | |1131 | BUFFER SORT | | 1 | |1132 | VIEW | | 1 | |1133 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B84_6E3611AA | 1 | |1134 | BUFFER SORT | | 1 | |1135 | VIEW | | 1 | |1136 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1137 | SORT GROUP BY | | 4 | |1138 | AN MERGE JOIN CARTESI | | 17 | |1139 | IAN MERGE JOIN CARTES | | 17 | |1140 | SIAN MERGE JOIN CARTE | | 17 | |1141 | ESIAN MERGE JOIN CART | | 17 | |1142 | HASH JOIN | | 15 | |1143 | VIEW | | 50 | |1144 | PUSHED RANK WINDOW SORT | | 50 | |1145 | S BY INDEX ROWID TABLE ACCES | VALUATIONS | 50 | |1146 | E SCAN INDEX RANG | VALUATIONS_IDX2 | 50 | |1147 | VIEW | | 15 | |1148 | Y SORT GROUP B | | 15 | |1149 | FILTER | | | |1150 | SS BY INDEX ROWID TABLE ACCE | VEHICLE_OVERHEADS | 20 | |1151 | GE SCAN INDEX RAN | VEHICLE_OVERHEADS_UK | 20 | |1152 | BUFFER SORT | | 1 | |1153 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |1154 | SCAN INDEX RANGE | PERFORMANCE_ELEMENTS_IX2 | 1 | |1155 | BUFFER SORT | | 1 | |1156 | VIEW | | 1 | |1157 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B83_6E3611AA | 1 | |1158 | BUFFER SORT | | 1 | |1159 | VIEW | | 1 | |1160 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B84_6E3611AA | 1 | |1161 | BUFFER SORT | | 1 | |1162 | VIEW | | 1 | |1163 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1164 | SORT GROUP BY | | 1 | |1165 | AN MERGE JOIN CARTESI | | 47087 | |1166 | IAN MERGE JOIN CARTES | | 47087 | |1167 | SIAN MERGE JOIN CARTE | | 47087 | |1168 | ESIAN MERGE JOIN CART | | 47087 | |1169 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1170 | UNION-ALL | | | |1171 | FILTER | | | |1172 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1173 | E SORT UNIQU | | 23543 | |1174 | UNION-ALL | | | |1175 | FILTER | | | |1176 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 4505 | |1177 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1178 | VIEW | | 19038 | |1179 | SORT WINDOW | | 19038 | |1180 | SORT WINDOW | | 19038 | |1181 | W SORT WINDO | | 19038 | |1182 | ATENATION CONC | | | |1183 | TER FIL | | | |1184 | STED LOOPS NE | | 19037 | |1185 | ILTER F | | | |1186 |.NESTED LOOPS OUTER | | 4505 | |1187 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1188 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1189 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1190 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | |1191 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | |1192 | TER FIL | | | |1193 | STED LOOPS NE | | | |1194 | ESTED LOOPS N | | 1 | |1195 |.FILTER | | | |1196 |. NESTED LOOPS OUTER | | 1 | |1197 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1198 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1199 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1200 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1201 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | |1202 | VIEW | | 23544 | |1203 | UNION-ALL | | | |1204 | PS NESTED LOO | | 1 | |1205 | VIEW | | 1 | |1206 | UFFER PUSHED RANK WINDOW B | | 1 | |1207 | OUP BY SORT GR | | 1 | |1208 | FILTER | | | |1209 | R FILTE | | | |1210 | JOIN HASH | | 1 | |1211 | LE ACCESS BY INDEX ROWID TAB | VEHICLE_METRICS | 1 | |1212 | DEX RANGE SCAN IN | VEHICLE_METRICS_PK | 1 | |1213 | W VIE | METRICS_V_ELEMENT_CLASS | 224 | |1214 | RT UNIQUE SO | | 224 | |1215 | NION-ALL U | | | |1216 |.HASH JOIN RIGHT OUTER | | 204 | |1217 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1218 |. HASH JOIN | | 204 | |1219 |. HASH JOIN | | 204 | |1220 |. INLIST ITERATOR | | | |1221 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1222 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1223 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1224 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1225 |.NESTED LOOPS | | 20 | |1226 |. HASH JOIN | | 765 | |1227 |. MERGE JOIN CARTESIAN | | 790 | |1228 |. INLIST ITERATOR | | | |1229 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1230 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1231 |. BUFFER SORT | | 158 | |1232 |. SORT UNIQUE | | 158 | |1233 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1234 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1235 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1236 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |1237 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |1238 | X RANGE SCAN INDE | POSITIONS_UK | 1 | |1239 | ESS BY INDEX ROWID TABLE ACC | PRR_MAPPINGS | 1 | |1240 | NGE SCAN INDEX RA | PRR_MAPPINGS_UX1 | 1 | |1241 | FILTER | | | |1242 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1243 | QUE SORT UNI | | 23543 | |1244 | LL UNION-A | | | |1245 | FILTER | | | |1246 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | |1247 | X RANGE SCAN INDE | POSITIONS_IDX2 | 4505 | |1248 | VIEW | | 19038 | |1249 | W SORT WINDO | | 19038 | |1250 | OW SORT WIND | | 19038 | |1251 | DOW SORT WIN | | 19038 | |1252 | NCATENATION CO | | | |1253 | ILTER F | | | |1254 |.NESTED LOOPS | | 19037 | |1255 |. FILTER | | | |1256 |. NESTED LOOPS OUTER | | 4505 | |1257 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1258 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1259 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1260 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1261 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1262 | ILTER F | | | |1263 |.NESTED LOOPS | | | |1264 |. NESTED LOOPS | | 1 | |1265 |. FILTER | | | |1266 |. NESTED LOOPS OUTER | | 1 | |1267 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1268 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1269 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1270 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1271 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1272 | BUFFER SORT | | 1 | |1273 | VIEW | | 1 | |1274 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B82_6E3611AA | 1 | |1275 | BUFFER SORT | | 1 | |1276 | VIEW | | 1 | |1277 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B83_6E3611AA | 1 | |1278 | BUFFER SORT | | 1 | |1279 | VIEW | | 1 | |1280 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B84_6E3611AA | 1 | |1281 | BUFFER SORT | | 1 | |1282 | VIEW | | 1 | |1283 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1284 | SORT GROUP BY | | 1 | |1285 | AN MERGE JOIN CARTESI | | 47087 | |1286 | IAN MERGE JOIN CARTES | | 47087 | |1287 | SIAN MERGE JOIN CARTE | | 47087 | |1288 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1289 | UNION-ALL | | | |1290 | FILTER | | | |1291 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1292 | SORT UNIQUE | | 23543 | |1293 | UNION-ALL | | | |1294 | FILTER | | | |1295 | CESS BY INDEX ROWID TABLE AC | POSITIONS | 4505 | |1296 | ANGE SCAN INDEX R | POSITIONS_IDX2 | 4505 | |1297 | VIEW | | 19038 | |1298 | ORT WINDOW S | | 19038 | |1299 | SORT WINDOW | | 19038 | |1300 | SORT WINDOW | | 19038 | |1301 | TENATION CONCA | | | |1302 | ER FILT | | | |1303 | TED LOOPS NES | | 19037 | |1304 | LTER FI | | | |1305 | ESTED LOOPS OUTER N | | 4505 | |1306 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1307 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1308 |.INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1309 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | | |1310 | NDEX RANGE SCAN I | POSITIONS_UK | 1 | |1311 | ER FILT | | | |1312 | TED LOOPS NES | | | |1313 | STED LOOPS NE | | 1 | |1314 | ILTER F | | | |1315 |.NESTED LOOPS OUTER | | 1 | |1316 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1317 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1318 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1319 | NDEX UNIQUE SCAN I | POSITIONS_PK | 1 | |1320 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 1 | |1321 | VIEW | | 23544 | |1322 | UNION-ALL | | | |1323 | S NESTED LOOP | | 1 | |1324 | VIEW | | 1 | |1325 | FFER PUSHED RANK WINDOW BU | | 1 | |1326 | UP BY SORT GRO | | 1 | |1327 | FILTER | | | |1328 | FILTER | | | |1329 | JOIN HASH | | 1 | |1330 | E ACCESS BY INDEX ROWID TABL | VEHICLE_METRICS | 1 | |1331 | EX RANGE SCAN IND | VEHICLE_METRICS_PK | 1 | |1332 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | |1333 | T UNIQUE SOR | | 224 | |1334 | ION-ALL UN | | | |1335 | ASH JOIN RIGHT OUTER H | | 204 | |1336 |.INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1337 |.HASH JOIN | | 204 | |1338 |. HASH JOIN | | 204 | |1339 |. INLIST ITERATOR | | | |1340 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1341 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1342 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1343 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1344 | ESTED LOOPS N | | 20 | |1345 |.HASH JOIN | | 765 | |1346 |. MERGE JOIN CARTESIAN | | 790 | |1347 |. INLIST ITERATOR | | | |1348 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1349 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1350 |. BUFFER SORT | | 158 | |1351 |. SORT UNIQUE | | 158 | |1352 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1353 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1354 |.INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1355 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |1356 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |1357 | RANGE SCAN INDEX | POSITIONS_UK | 1 | |1358 | SS BY INDEX ROWID TABLE ACCE | PRR_MAPPINGS | 1 | |1359 | GE SCAN INDEX RAN | PRR_MAPPINGS_UX1 | 1 | |1360 | FILTER | | | |1361 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1362 | UE SORT UNIQ | | 23543 | |1363 | L UNION-AL | | | |1364 | FILTER | | | |1365 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | |1366 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1367 | VIEW | | 19038 | |1368 | SORT WINDOW | | 19038 | |1369 | W SORT WINDO | | 19038 | |1370 | OW SORT WIND | | 19038 | |1371 | CATENATION CON | | | |1372 | LTER FI | | | |1373 | ESTED LOOPS N | | 19037 | |1374 |.FILTER | | | |1375 |. NESTED LOOPS OUTER | | 4505 | |1376 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1377 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1378 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1379 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1380 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1381 | LTER FI | | | |1382 | ESTED LOOPS N | | | |1383 |.NESTED LOOPS | | 1 | |1384 |. FILTER | | | |1385 |. NESTED LOOPS OUTER | | 1 | |1386 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1387 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1388 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1389 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1390 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1391 | BUFFER SORT | | 1 | |1392 | VIEW | | 1 | |1393 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B83_6E3611AA | 1 | |1394 | BUFFER SORT | | 1 | |1395 | VIEW | | 1 | |1396 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B84_6E3611AA | 1 | |1397 | BUFFER SORT | | 1 | |1398 | VIEW | | 1 | |1399 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1400 | SORT GROUP BY | | 1 | |1401 | AN MERGE JOIN CARTESI | | 47087 | |1402 | IAN MERGE JOIN CARTES | | 47087 | |1403 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1404 | UNION-ALL | | | |1405 | FILTER | | | |1406 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1407 | SORT UNIQUE | | 23543 | |1408 | UNION-ALL | | | |1409 | FILTER | | | |1410 | ESS BY INDEX ROWID TABLE ACC | POSITIONS | 4505 | |1411 | NGE SCAN INDEX RA | POSITIONS_IDX2 | 4505 | |1412 | VIEW | | 19038 | |1413 | RT WINDOW SO | | 19038 | |1414 | ORT WINDOW S | | 19038 | |1415 | SORT WINDOW | | 19038 | |1416 | ENATION CONCAT | | | |1417 | R FILTE | | | |1418 | ED LOOPS NEST | | 19037 | |1419 | TER FIL | | | |1420 | STED LOOPS OUTER NE | | 4505 | |1421 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 4505 | |1422 |.INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1423 | NDEX RANGE SCAN I | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1424 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | | |1425 | DEX RANGE SCAN IN | POSITIONS_UK | 1 | |1426 | R FILTE | | | |1427 | ED LOOPS NEST | | | |1428 | TED LOOPS NES | | 1 | |1429 | LTER FI | | | |1430 | ESTED LOOPS OUTER N | | 1 | |1431 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1432 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1433 |.INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1434 | DEX UNIQUE SCAN IN | POSITIONS_PK | 1 | |1435 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 1 | |1436 | VIEW | | 23544 | |1437 | UNION-ALL | | | |1438 | NESTED LOOPS | | 1 | |1439 | VIEW | | 1 | |1440 | FER PUSHED RANK WINDOW BUF | | 1 | |1441 | P BY SORT GROU | | 1 | |1442 | FILTER | | | |1443 | FILTER | | | |1444 | OIN HASH J | | 1 | |1445 | ACCESS BY INDEX ROWID TABLE | VEHICLE_METRICS | 1 | |1446 | X RANGE SCAN INDE | VEHICLE_METRICS_PK | 1 | |1447 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | |1448 | UNIQUE SORT | | 224 | |1449 | ON-ALL UNI | | | |1450 | SH JOIN RIGHT OUTER HA | | 204 | |1451 | NDEX FULL SCAN I | PK_ELEMENT_AGGREGATES | 158 | |1452 | ASH JOIN H | | 204 | |1453 |.HASH JOIN | | 204 | |1454 |. INLIST ITERATOR | | | |1455 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1456 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1457 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1458 |.TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1459 | STED LOOPS NE | | 20 | |1460 | ASH JOIN H | | 765 | |1461 |.MERGE JOIN CARTESIAN | | 790 | |1462 |. INLIST ITERATOR | | | |1463 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1464 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1465 |. BUFFER SORT | | 158 | |1466 |. SORT UNIQUE | | 158 | |1467 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1468 |.TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1469 | NDEX UNIQUE SCAN I | PK_CLASSIFICATION_ELEMENTS | 1 | |1470 | ANGE SCAN INDEX R | VEHICLE_METRICS_PK | 1 | |1471 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 1 | |1472 | RANGE SCAN INDEX | POSITIONS_UK | 1 | |1473 | S BY INDEX ROWID TABLE ACCES | PRR_MAPPINGS | 1 | |1474 | E SCAN INDEX RANG | PRR_MAPPINGS_UX1 | 1 | |1475 | FILTER | | | |1476 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1477 | E SORT UNIQU | | 23543 | |1478 | UNION-ALL | | | |1479 | FILTER | | | |1480 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 4505 | |1481 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1482 | VIEW | | 19038 | |1483 | SORT WINDOW | | 19038 | |1484 | SORT WINDOW | | 19038 | |1485 | W SORT WINDO | | 19038 | |1486 | ATENATION CONC | | | |1487 | TER FIL | | | |1488 | STED LOOPS NE | | 19037 | |1489 | ILTER F | | | |1490 |.NESTED LOOPS OUTER | | 4505 | |1491 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1492 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1493 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1494 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | |1495 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | |1496 | TER FIL | | | |1497 | STED LOOPS NE | | | |1498 | ESTED LOOPS N | | 1 | |1499 |.FILTER | | | |1500 |. NESTED LOOPS OUTER | | 1 | |1501 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1502 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1503 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1504 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1505 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | |1506 | BUFFER SORT | | 1 | |1507 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |1508 | CAN INDEX UNIQUE S | PERFORMANCE_ELEMENTS_UK1 | 1 | |1509 | BUFFER SORT | | 1 | |1510 | VIEW | | 1 | |1511 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1512 | SORT GROUP BY | | 194 | |1513 | AN MERGE JOIN CARTESI | | 40908 | |1514 | UTER HASH JOIN RIGHT O | | 40908 | |1515 | L TABLE ACCESS FUL | PRR_MAPPINGS | 599 | |1516 | HASH JOIN | | 40908 | <----- |1517 | ESIAN MERGE JOIN CART | | 47087 | <----- |1518 | TESIAN MERGE JOIN CAR | | 47087 | |1519 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1520 | UNION-ALL | | | |1521 | FILTER | | | |1522 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1523 | UE SORT UNIQ | | 23543 | |1524 | L UNION-AL | | | |1525 | FILTER | | | |1526 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | |1527 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1528 | VIEW | | 19038 | |1529 | SORT WINDOW | | 19038 | |1530 | W SORT WINDO | | 19038 | |1531 | OW SORT WIND | | 19038 | |1532 | CATENATION CON | | | |1533 | LTER FI | | | |1534 | ESTED LOOPS N | | 19037 | |1535 |.FILTER | | | |1536 |. NESTED LOOPS OUTER | | 4505 | |1537 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1538 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1539 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1540 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1541 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1542 | LTER FI | | | |1543 | ESTED LOOPS N | | | |1544 |.NESTED LOOPS | | 1 | |1545 |. FILTER | | | |1546 |. NESTED LOOPS OUTER | | 1 | |1547 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1548 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1549 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1550 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1551 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1552 | VIEW | | 23544 | |1553 | UNION-ALL | | | |1554 | OPS NESTED LO | | 1 | |1555 | VIEW | | 1 | |1556 | BUFFER PUSHED RANK WINDOW | | 1 | |1557 | ROUP BY SORT G | | 1 | |1558 | R FILTE | | | |1559 | ER FILT | | | |1560 | H JOIN HAS | | 1 | |1561 | BLE ACCESS BY INDEX ROWID TA | VEHICLE_METRICS | 1 | |1562 | NDEX RANGE SCAN I | VEHICLE_METRICS_PK | 1 | |1563 | EW VI | METRICS_V_ELEMENT_CLASS | 224 | |1564 | ORT UNIQUE S | | 224 | |1565 |.UNION-ALL | | | |1566 |. HASH JOIN RIGHT OUTER | | 204 | |1567 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1568 |. HASH JOIN | | 204 | |1569 |. HASH JOIN | | 204 | |1570 |. INLIST ITERATOR | | | |1571 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1572 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1573 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1574 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1575 |. NESTED LOOPS | | 20 | |1576 |. HASH JOIN | | 765 | |1577 |. MERGE JOIN CARTESIAN | | 790 | |1578 |. INLIST ITERATOR | | | |1579 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1580 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1581 |. BUFFER SORT | | 158 | |1582 |. SORT UNIQUE | | 158 | |1583 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1584 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1585 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1586 | X RANGE SCAN INDE | VEHICLE_METRICS_PK | 1 | |1587 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | |1588 | EX RANGE SCAN IND | POSITIONS_UK | 1 | |1589 | CESS BY INDEX ROWID TABLE AC | PRR_MAPPINGS | 1 | |1590 | ANGE SCAN INDEX R | PRR_MAPPINGS_UX1 | 1 | |1591 | FILTER | | | |1592 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1593 | IQUE SORT UN | | 23543 | |1594 | ALL UNION- | | | |1595 | R FILTE | | | |1596 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | |1597 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | |1598 | VIEW | | 19038 | |1599 | OW SORT WIND | | 19038 | |1600 | DOW SORT WIN | | 19038 | |1601 | NDOW SORT WI | | 19038 | |1602 | ONCATENATION C | | | |1603 |.FILTER | | | |1604 |. NESTED LOOPS | | 19037 | |1605 |. FILTER | | | |1606 |. NESTED LOOPS OUTER | | 4505 | |1607 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1608 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1609 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1610 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1611 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1612 |.FILTER | | | |1613 |. NESTED LOOPS | | | |1614 |. NESTED LOOPS | | 1 | |1615 |. FILTER | | | |1616 |. NESTED LOOPS OUTER | | 1 | |1617 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1618 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1619 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1620 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1621 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1622 | BUFFER SORT | | 1 | |1623 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |1624 | E SCAN INDEX UNIQU | PERFORMANCE_ELEMENTS_UK1 | 1 | |1625 | BUFFER SORT | | 1 | |1626 | VIEW | | 1 | |1627 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1628 | LL TABLE ACCESS FU | POSITIONS | 7266K| <----- |1629 | BUFFER SORT | | 1 | |1630 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |1631 | AN INDEX UNIQUE SC | PERFORMANCE_ELEMENTS_UK1 | 1 | |1632 | SORT GROUP BY | | 637 | |1633 | AN MERGE JOIN CARTESI | | 40908 | |1634 | R NESTED LOOPS OUTE | | 40908 | |1635 | HASH JOIN | | 40908 | <----- |1636 | ESIAN MERGE JOIN CART | | 47087 | |1637 | TESIAN MERGE JOIN CAR | | 47087 | |1638 | VIEW | POSITIONS_LOOKTHROUGH | 47087 | |1639 | UNION-ALL | | | |1640 | FILTER | | | |1641 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1642 | UE SORT UNIQ | | 23543 | |1643 | L UNION-AL | | | |1644 | FILTER | | | |1645 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 4505 | |1646 | RANGE SCAN INDEX | POSITIONS_IDX2 | 4505 | |1647 | VIEW | | 19038 | |1648 | SORT WINDOW | | 19038 | |1649 | W SORT WINDO | | 19038 | |1650 | OW SORT WIND | | 19038 | |1651 | CATENATION CON | | | |1652 | LTER FI | | | |1653 | ESTED LOOPS N | | 19037 | |1654 |.FILTER | | | |1655 |. NESTED LOOPS OUTER | | 4505 | |1656 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1657 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1658 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1659 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1660 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1661 | LTER FI | | | |1662 | ESTED LOOPS N | | | |1663 |.NESTED LOOPS | | 1 | |1664 |. FILTER | | | |1665 |. NESTED LOOPS OUTER | | 1 | |1666 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1667 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1668 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1669 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1670 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1671 | VIEW | | 23544 | |1672 | UNION-ALL | | | |1673 | OPS NESTED LO | | 1 | |1674 | VIEW | | 1 | |1675 | BUFFER PUSHED RANK WINDOW | | 1 | |1676 | ROUP BY SORT G | | 1 | |1677 | R FILTE | | | |1678 | ER FILT | | | |1679 | H JOIN HAS | | 1 | |1680 | BLE ACCESS BY INDEX ROWID TA | VEHICLE_METRICS | 1 | |1681 | NDEX RANGE SCAN I | VEHICLE_METRICS_PK | 1 | |1682 | EW VI | METRICS_V_ELEMENT_CLASS | 224 | |1683 | ORT UNIQUE S | | 224 | |1684 |.UNION-ALL | | | |1685 |. HASH JOIN RIGHT OUTER | | 204 | |1686 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1687 |. HASH JOIN | | 204 | |1688 |. HASH JOIN | | 204 | |1689 |. INLIST ITERATOR | | | |1690 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1691 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1692 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1693 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1694 |. NESTED LOOPS | | 20 | |1695 |. HASH JOIN | | 765 | |1696 |. MERGE JOIN CARTESIAN | | 790 | |1697 |. INLIST ITERATOR | | | |1698 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1699 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1700 |. BUFFER SORT | | 158 | |1701 |. SORT UNIQUE | | 158 | |1702 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1703 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1704 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1705 | X RANGE SCAN INDE | VEHICLE_METRICS_PK | 1 | |1706 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | |1707 | EX RANGE SCAN IND | POSITIONS_UK | 1 | |1708 | CESS BY INDEX ROWID TABLE AC | PRR_MAPPINGS | 1 | |1709 | ANGE SCAN INDEX R | PRR_MAPPINGS_UX1 | 1 | |1710 | FILTER | | | |1711 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 23543 | |1712 | IQUE SORT UN | | 23543 | |1713 | ALL UNION- | | | |1714 | R FILTE | | | |1715 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 4505 | |1716 | EX RANGE SCAN IND | POSITIONS_IDX2 | 4505 | |1717 | VIEW | | 19038 | |1718 | OW SORT WIND | | 19038 | |1719 | DOW SORT WIN | | 19038 | |1720 | NDOW SORT WI | | 19038 | |1721 | ONCATENATION C | | | |1722 |.FILTER | | | |1723 |. NESTED LOOPS | | 19037 | |1724 |. FILTER | | | |1725 |. NESTED LOOPS OUTER | | 4505 | |1726 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1727 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1728 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1729 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | |1730 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |1731 |.FILTER | | | |1732 |. NESTED LOOPS | | | |1733 |. NESTED LOOPS | | 1 | |1734 |. FILTER | | | |1735 |. NESTED LOOPS OUTER | | 1 | |1736 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 4505 | |1737 |. INDEX RANGE SCAN | POSITIONS_IDX2 | 4505 | |1738 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |1739 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |1740 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |1741 | BUFFER SORT | | 1 | |1742 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |1743 | E SCAN INDEX UNIQU | PERFORMANCE_ELEMENTS_UK1 | 1 | |1744 | BUFFER SORT | | 1 | |1745 | VIEW | | 1 | |1746 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B85_6E3611AA | 1 | |1747 | LL TABLE ACCESS FU | POSITIONS | 7266K| <----- |1748 | VIEW | | 1 | |1749 | INDEX ROWID TABLE ACCESS BY | PRR_MAPPINGS | 1 | |1750 | AN INDEX RANGE SC | PRR_MAPPINGS_UX1 | 1 | |1751 | BUFFER SORT | | 1 | |1752 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |1753 | AN INDEX UNIQUE SC | PERFORMANCE_ELEMENTS_UK1 | 1 | |1754 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | |1755 | MERGE JOIN CARTESIAN | | 1 | |1756 | NESTED LOOPS | | | |1757 | NESTED LOOPS | | 1 | |1758 | NESTED LOOPS | | 1 | |1759 | NESTED LOOPS | | 1 | |1760 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | |1761 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | |1762 | VIEW | | 1 | |1763 | WINDOW BUFFER PUSHED RANK | | 1 | |1764 | SORT GROUP BY | | 1 | |1765 | FILTER | | | |1766 | FILTER | | | |1767 | HASH JOIN | | 1 | |1768 | ROWID TABLE ACCESS BY INDEX | VEHICLE_METRICS | 1 | |1769 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | |1770 | VIEW | METRICS_V_ELEMENT_CLASS | 2541 | |1771 | SORT UNIQUE | | 2541 | |1772 | UNION-ALL | | | |1773 | CONCATENATION | | | |1774 | FILTER | | | |1775 | OUTER HASH JOIN RIGHT | | 2078 | |1776 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1777 | HASH JOIN | | 2078 | |1778 | ULL TABLE ACCESS F | PERFORMANCE_ELEMENTS | 1863 | |1779 | HASH JOIN | | 2078 | |1780 | BY INDEX ROWID TABLE ACCESS | CLASSIFICATIONS | 51 | |1781 | CAN INDEX FULL S | CLASSIFICATIONS_IX2 | 51 | |1782 | LL SCAN INDEX FAST FU | PK_CLASSIFICATION_ELEMENTS | 2078 | |1783 | FILTER | | | |1784 | OUTER HASH JOIN RIGHT | | 448 | |1785 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1786 | HASH JOIN | | 448 | |1787 | HASH JOIN | | 448 | |1788 | BY INDEX ROWID TABLE ACCESS | CLASSIFICATIONS | 11 | |1789 | SCAN INDEX RANGE | CLASSIFICATIONS_IX2 | 11 | |1790 | LL SCAN INDEX FAST FU | PK_CLASSIFICATION_ELEMENTS | 2078 | |1791 | ULL TABLE ACCESS F | PERFORMANCE_ELEMENTS | 1863 | |1792 | CONCATENATION | | | |1793 | FILTER | | | |1794 | HASH JOIN | | 12 | |1795 | HASH JOIN | | 12 | |1796 | T SEMI HASH JOIN RIGH | | 9 | |1797 | AN INDEX FULL SC | PK_ELEMENT_AGGREGATES | 158 | |1798 | FULL TABLE ACCESS | PERFORMANCE_ELEMENTS | 1863 | |1799 | L SCAN INDEX FAST FUL | PK_CLASSIFICATION_ELEMENTS | 2078 | |1800 | INDEX ROWID TABLE ACCESS BY | CLASSIFICATIONS | 51 | |1801 | N INDEX FULL SCA | CLASSIFICATIONS_IX2 | 51 | |1802 | FILTER | | | |1803 | HASH JOIN | | 3 | |1804 | HASH JOIN | | 12 | |1805 | T SEMI HASH JOIN RIGH | | 9 | |1806 | AN INDEX FULL SC | PK_ELEMENT_AGGREGATES | 158 | |1807 | FULL TABLE ACCESS | PERFORMANCE_ELEMENTS | 1863 | |1808 | L SCAN INDEX FAST FUL | PK_CLASSIFICATION_ELEMENTS | 2078 | |1809 | INDEX ROWID TABLE ACCESS BY | CLASSIFICATIONS | 11 | |1810 | AN INDEX RANGE SC | CLASSIFICATIONS_IX2 | 11 | |1811 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | |1812 | OWID TABLE ACCESS BY INDEX R | POSITIONS | 1 | |1813 | INDEX RANGE SCAN | POSITIONS_UK | 1 | |1814 | TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 1 | |1815 | INDEX UNIQUE SCAN | CLASSIFICATIONS_PK | 1 | |1816 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_PK | 1 | |1817 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | |1818 | BUFFER SORT | | 1 | |1819 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | |1820 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | |1821 | HASH GROUP BY | | 42 | |1822 | FILTER | | | |1823 | VIEW | | 42 | |1824 | UNION-ALL | | | |1825 | NESTED LOOPS | | 1 | |1826 | NESTED LOOPS | | 1 | |1827 | VIEW | | 50 | |1828 | WINDOW SORT PUSHED RANK | | 50 | |1829 | FILTER | | | |1830 | D TABLE ACCESS BY INDEX ROWI | VALUATIONS | 50 | |1831 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | |1832 | TABLE ACCESS BY INDEX ROWID | PRR_MAPPINGS | 1 | |1833 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | |1834 | TCH COLLECTION ITERATOR PICKLER FE | GET_METRICS_ALLOC_CONTRIBS_BAS | | |1835 | NESTED LOOPS | | 41 | |1836 | VIEW | | 50 | |1837 | WINDOW SORT PUSHED RANK | | 50 | |1838 | FILTER | | | |1839 | TABLE ACCESS BY INDEX ROWID | VALUATIONS | 50 | |1840 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | |1841 | TCH COLLECTION ITERATOR PICKLER FE | GET_METRICS_ALLOC_CONTRIBS_BAS | | |1842 | VIEW | METRICS_V_ALLOC_CONTRIB | 130 | |1843 | UNION-ALL | | | |1844 | FILTER | | | |1845 | VIEW | | 88 | |1846 | UNION-ALL | | | |1847 | FILTER | | | |1848 | HASH JOIN | | 1736 | |1849 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1850 | HASH JOIN | | 1736 | |1851 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |1852 | FILTER | | | |1853 | HASH JOIN RIGHT OUTER | | 1736 | |1854 | VIEW | METRICS_V_TARGETS | 1 | |1855 | HASH GROUP BY | | 1 | |1856 | INLIST ITERATOR | | | |1857 | WID TABLE ACCESS BY INDEX RO | VEHICLE_METRICS | 5 | |1858 | INDEX RANGE SCAN | VEHICLE_METRICS_IDX2 | 5 | |1859 | NESTED LOOPS | | 17807 | |1860 | D TABLE ACCESS BY INDEX ROWI | VEHICLES | 1 | |1861 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | |1862 | VIEW | | 17807 | |1863 | FILTER | | | |1864 | SORT GROUP BY | | 17807 | |1865 | HASH JOIN | | 17807 | |1866 | VIEW | METRICS_V_ELEMENT_CLASS | 2090 | |1867 | SORT UNIQUE | | 2090 | |1868 | UNION-ALL | | | |1869 | ER HASH JOIN RIGHT OUT | | 2078 | |1870 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1871 | HASH JOIN | | 2078 | |1872 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1873 | HASH JOIN | | 2078 | |1874 | L TABLE ACCESS FUL | CLASSIFICATIONS | 51 | |1875 | SCAN INDEX FAST FULL | PK_CLASSIFICATION_ELEMENTS | 2078 | |1876 | HASH JOIN | | 12 | |1877 | HASH JOIN | | 12 | |1878 | EMI HASH JOIN RIGHT S | | 9 | |1879 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1880 | L TABLE ACCESS FUL | PERFORMANCE_ELEMENTS | 1863 | |1881 | CAN INDEX FAST FULL S | PK_CLASSIFICATION_ELEMENTS | 2078 | |1882 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |1883 | VIEW | METRICS_V_POSITIONS | 852 | |1884 | TION TEMP TABLE TRANSFORMA | | | |1885 | LOAD AS SELECT | | | |1886 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1887 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1888 | LOAD AS SELECT | | | |1889 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1890 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1891 | LOAD AS SELECT | | | |1892 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1893 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_UK1 | 1 | |1894 | LOAD AS SELECT | | | |1895 | EX ROWID TABLE ACCESS BY IND | PERFORMANCE_ELEMENTS | 1 | |1896 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | |1897 | UNION-ALL | | | |1898 | SORT GROUP BY | | 1 | |1899 | AN MERGE JOIN CARTESI | | 799K| |1900 | IAN MERGE JOIN CARTES | | 799K| |1901 | SIAN MERGE JOIN CARTE | | 799K| |1902 | ESIAN MERGE JOIN CART | | 799K| |1903 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |1904 | UNION-ALL | | | |1905 | FILTER | | | |1906 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |1907 | E SORT UNIQU | | 399K| |1908 | UNION-ALL | | | |1909 | FILTER | | | |1910 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 114K| |1911 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| |1912 | VIEW | | 285K| |1913 | SORT WINDOW | | 285K| |1914 | SORT WINDOW | | 285K| |1915 | W SORT WINDO | | 285K| |1916 | ATENATION CONC | | | |1917 | TER FIL | | | |1918 | STED LOOPS NE | | 285K| <----- |1919 | ILTER F | | | <----- |1920 |.NESTED LOOPS OUTER | | 114K| <----- |1921 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |1922 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |1923 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |1924 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | <----- |1925 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |1926 | TER FIL | | | |1927 | STED LOOPS NE | | | |1928 | ESTED LOOPS N | | 1 | |1929 |.FILTER | | | |1930 |. NESTED LOOPS OUTER | | 1 | |1931 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |1932 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |1933 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |1934 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | <----- |1935 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | <----- |1936 | VIEW | | 399K| <----- |1937 | UNION-ALL | | | |1938 | PS NESTED LOO | | 1 | |1939 | VIEW | | 1 | |1940 | UFFER PUSHED RANK WINDOW B | | 1 | |1941 | OUP BY SORT GR | | 1 | |1942 | FILTER | | | |1943 | R FILTE | | | |1944 | JOIN HASH | | 1 | |1945 | LE ACCESS BY INDEX ROWID TAB | VEHICLE_METRICS | 6 | |1946 | DEX RANGE SCAN IN | VEHICLE_METRICS_IDX2 | 492 | |1947 | W VIE | METRICS_V_ELEMENT_CLASS | 224 | |1948 | RT UNIQUE SO | | 224 | |1949 | NION-ALL U | | | |1950 |.HASH JOIN RIGHT OUTER | | 204 | |1951 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1952 |. HASH JOIN | | 204 | |1953 |. HASH JOIN | | 204 | |1954 |. INLIST ITERATOR | | | |1955 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1956 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1957 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |1958 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1959 |.NESTED LOOPS | | 20 | |1960 |. HASH JOIN | | 765 | |1961 |. MERGE JOIN CARTESIAN | | 790 | |1962 |. INLIST ITERATOR | | | |1963 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |1964 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |1965 |. BUFFER SORT | | 158 | |1966 |. SORT UNIQUE | | 158 | |1967 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |1968 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |1969 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |1970 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |1971 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |1972 | X RANGE SCAN INDE | POSITIONS_UK | 1 | |1973 | ESS BY INDEX ROWID TABLE ACC | PRR_MAPPINGS | 1 | |1974 | NGE SCAN INDEX RA | PRR_MAPPINGS_UX1 | 1 | |1975 | FILTER | | | |1976 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |1977 | QUE SORT UNI | | 399K| |1978 | LL UNION-A | | | |1979 | FILTER | | | |1980 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 114K| |1981 | X RANGE SCAN INDE | POSITIONS_IDX1 | 114K| |1982 | VIEW | | 285K| |1983 | W SORT WINDO | | 285K| |1984 | OW SORT WIND | | 285K| |1985 | DOW SORT WIN | | 285K| |1986 | NCATENATION CO | | | |1987 | ILTER F | | | |1988 |.NESTED LOOPS | | 285K| |1989 |. FILTER | | | <----- |1990 |. NESTED LOOPS OUTER | | 114K| <----- |1991 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |1992 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |1993 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |1994 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | <----- |1995 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |1996 | ILTER F | | | |1997 |.NESTED LOOPS | | | |1998 |. NESTED LOOPS | | 1 | |1999 |. FILTER | | | |2000 |. NESTED LOOPS OUTER | | 1 | |2001 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2002 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2003 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2004 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |2005 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |2006 | BUFFER SORT | | 1 | |2007 | VIEW | | 1 | |2008 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7E_6E3611AA | 1 | |2009 | BUFFER SORT | | 1 | |2010 | VIEW | | 1 | |2011 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7F_6E3611AA | 1 | |2012 | BUFFER SORT | | 1 | |2013 | VIEW | | 1 | |2014 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B80_6E3611AA | 1 | |2015 | BUFFER SORT | | 1 | |2016 | VIEW | | 1 | |2017 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2018 | SORT GROUP BY | | 17 | |2019 | AN MERGE JOIN CARTESI | | 17 | |2020 | IAN MERGE JOIN CARTES | | 17 | |2021 | SIAN MERGE JOIN CARTE | | 17 | |2022 | ESIAN MERGE JOIN CART | | 17 | |2023 | HASH JOIN | | 15 | |2024 | VIEW | | 50 | |2025 | PUSHED RANK WINDOW SORT | | 50 | |2026 | S BY INDEX ROWID TABLE ACCES | VALUATIONS | 50 | |2027 | E SCAN INDEX RANG | VALUATIONS_IDX2 | 50 | |2028 | VIEW | | 15 | |2029 | Y SORT GROUP B | | 15 | |2030 | FILTER | | | |2031 | SS BY INDEX ROWID TABLE ACCE | VEHICLE_OVERHEADS | 20 | |2032 | GE SCAN INDEX RAN | VEHICLE_OVERHEADS_UK | 20 | |2033 | BUFFER SORT | | 1 | |2034 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |2035 | SCAN INDEX RANGE | PERFORMANCE_ELEMENTS_IX2 | 1 | |2036 | BUFFER SORT | | 1 | |2037 | VIEW | | 1 | |2038 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7F_6E3611AA | 1 | |2039 | BUFFER SORT | | 1 | |2040 | VIEW | | 1 | |2041 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B80_6E3611AA | 1 | |2042 | BUFFER SORT | | 1 | |2043 | VIEW | | 1 | |2044 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2045 | SORT GROUP BY | | 1 | |2046 | AN MERGE JOIN CARTESI | | 799K| |2047 | IAN MERGE JOIN CARTES | | 799K| |2048 | SIAN MERGE JOIN CARTE | | 799K| |2049 | ESIAN MERGE JOIN CART | | 799K| |2050 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |2051 | UNION-ALL | | | |2052 | FILTER | | | |2053 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2054 | E SORT UNIQU | | 399K| |2055 | UNION-ALL | | | |2056 | FILTER | | | |2057 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 114K| |2058 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| |2059 | VIEW | | 285K| |2060 | SORT WINDOW | | 285K| |2061 | SORT WINDOW | | 285K| |2062 | W SORT WINDO | | 285K| |2063 | ATENATION CONC | | | |2064 | TER FIL | | | |2065 | STED LOOPS NE | | 285K| <----- |2066 | ILTER F | | | <----- |2067 |.NESTED LOOPS OUTER | | 114K| <----- |2068 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2069 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2070 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2071 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | <----- |2072 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | |2073 | TER FIL | | | |2074 | STED LOOPS NE | | | |2075 | ESTED LOOPS N | | 1 | |2076 |.FILTER | | | |2077 |. NESTED LOOPS OUTER | | 1 | |2078 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2079 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2080 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2081 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | <----- |2082 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | <----- |2083 | VIEW | | 399K| <----- |2084 | UNION-ALL | | | |2085 | PS NESTED LOO | | 1 | |2086 | VIEW | | 1 | |2087 | UFFER PUSHED RANK WINDOW B | | 1 | |2088 | OUP BY SORT GR | | 1 | |2089 | FILTER | | | |2090 | R FILTE | | | |2091 | JOIN HASH | | 1 | |2092 | LE ACCESS BY INDEX ROWID TAB | VEHICLE_METRICS | 6 | |2093 | DEX RANGE SCAN IN | VEHICLE_METRICS_IDX2 | 492 | |2094 | W VIE | METRICS_V_ELEMENT_CLASS | 224 | |2095 | RT UNIQUE SO | | 224 | |2096 | NION-ALL U | | | |2097 |.HASH JOIN RIGHT OUTER | | 204 | |2098 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2099 |. HASH JOIN | | 204 | |2100 |. HASH JOIN | | 204 | |2101 |. INLIST ITERATOR | | | |2102 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2103 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2104 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2105 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2106 |.NESTED LOOPS | | 20 | |2107 |. HASH JOIN | | 765 | |2108 |. MERGE JOIN CARTESIAN | | 790 | |2109 |. INLIST ITERATOR | | | |2110 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2111 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2112 |. BUFFER SORT | | 158 | |2113 |. SORT UNIQUE | | 158 | |2114 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2115 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2116 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |2117 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |2118 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |2119 | X RANGE SCAN INDE | POSITIONS_UK | 1 | |2120 | ESS BY INDEX ROWID TABLE ACC | PRR_MAPPINGS | 1 | |2121 | NGE SCAN INDEX RA | PRR_MAPPINGS_UX1 | 1 | |2122 | FILTER | | | |2123 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2124 | QUE SORT UNI | | 399K| |2125 | LL UNION-A | | | |2126 | FILTER | | | |2127 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 114K| |2128 | X RANGE SCAN INDE | POSITIONS_IDX1 | 114K| |2129 | VIEW | | 285K| |2130 | W SORT WINDO | | 285K| |2131 | OW SORT WIND | | 285K| |2132 | DOW SORT WIN | | 285K| |2133 | NCATENATION CO | | | |2134 | ILTER F | | | |2135 |.NESTED LOOPS | | 285K| <----- |2136 |. FILTER | | | <----- |2137 |. NESTED LOOPS OUTER | | 114K| <----- |2138 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2139 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2140 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2141 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | <----- |2142 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |2143 | ILTER F | | | |2144 |.NESTED LOOPS | | | |2145 |. NESTED LOOPS | | 1 | |2146 |. FILTER | | | |2147 |. NESTED LOOPS OUTER | | 1 | |2148 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2149 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2150 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2151 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |2152 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |2153 | BUFFER SORT | | 1 | |2154 | VIEW | | 1 | |2155 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7E_6E3611AA | 1 | |2156 | BUFFER SORT | | 1 | |2157 | VIEW | | 1 | |2158 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7F_6E3611AA | 1 | |2159 | BUFFER SORT | | 1 | |2160 | VIEW | | 1 | |2161 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B80_6E3611AA | 1 | |2162 | BUFFER SORT | | 1 | |2163 | VIEW | | 1 | |2164 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2165 | SORT GROUP BY | | 1 | |2166 | AN MERGE JOIN CARTESI | | 799K| |2167 | IAN MERGE JOIN CARTES | | 799K| |2168 | SIAN MERGE JOIN CARTE | | 799K| |2169 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |2170 | UNION-ALL | | | |2171 | FILTER | | | |2172 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2173 | SORT UNIQUE | | 399K| |2174 | UNION-ALL | | | |2175 | FILTER | | | |2176 | CESS BY INDEX ROWID TABLE AC | POSITIONS | 114K| |2177 | ANGE SCAN INDEX R | POSITIONS_IDX1 | 114K| |2178 | VIEW | | 285K| |2179 | ORT WINDOW S | | 285K| |2180 | SORT WINDOW | | 285K| |2181 | SORT WINDOW | | 285K| |2182 | TENATION CONCA | | | |2183 | ER FILT | | | |2184 | TED LOOPS NES | | 285K| <----- |2185 | LTER FI | | | <----- |2186 | ESTED LOOPS OUTER N | | 114K| <----- |2187 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2188 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2189 |.INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2190 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | | <----- |2191 | NDEX RANGE SCAN I | POSITIONS_UK | 1 | <----- |2192 | ER FILT | | | |2193 | TED LOOPS NES | | | |2194 | STED LOOPS NE | | 1 | |2195 | ILTER F | | | |2196 |.NESTED LOOPS OUTER | | 1 | |2197 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2198 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2199 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2200 | NDEX UNIQUE SCAN I | POSITIONS_PK | 1 | |2201 | BLE ACCESS BY INDEX ROWID TA | POSITIONS | 1 | |2202 | VIEW | | 399K| |2203 | UNION-ALL | | | |2204 | S NESTED LOOP | | 1 | |2205 | VIEW | | 1 | |2206 | FFER PUSHED RANK WINDOW BU | | 1 | |2207 | UP BY SORT GRO | | 1 | |2208 | FILTER | | | |2209 | FILTER | | | |2210 | JOIN HASH | | 1 | |2211 | E ACCESS BY INDEX ROWID TABL | VEHICLE_METRICS | 6 | |2212 | EX RANGE SCAN IND | VEHICLE_METRICS_IDX2 | 492 | <----- |2213 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | |2214 | T UNIQUE SOR | | 224 | |2215 | ION-ALL UN | | | |2216 | ASH JOIN RIGHT OUTER H | | 204 | |2217 |.INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2218 |.HASH JOIN | | 204 | |2219 |. HASH JOIN | | 204 | |2220 |. INLIST ITERATOR | | | |2221 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2222 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2223 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2224 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2225 | ESTED LOOPS N | | 20 | |2226 |.HASH JOIN | | 765 | |2227 |. MERGE JOIN CARTESIAN | | 790 | |2228 |. INLIST ITERATOR | | | |2229 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2230 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2231 |. BUFFER SORT | | 158 | |2232 |. SORT UNIQUE | | 158 | |2233 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2234 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2235 |.INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |2236 | RANGE SCAN INDEX | VEHICLE_METRICS_PK | 1 | |2237 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 1 | |2238 | RANGE SCAN INDEX | POSITIONS_UK | 1 | |2239 | SS BY INDEX ROWID TABLE ACCE | PRR_MAPPINGS | 1 | |2240 | GE SCAN INDEX RAN | PRR_MAPPINGS_UX1 | 1 | |2241 | FILTER | | | |2242 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2243 | UE SORT UNIQ | | 399K| |2244 | L UNION-AL | | | |2245 | FILTER | | | |2246 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 114K| |2247 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| |2248 | VIEW | | 285K| |2249 | SORT WINDOW | | 285K| |2250 | W SORT WINDO | | 285K| |2251 | OW SORT WIND | | 285K| |2252 | CATENATION CON | | | |2253 | LTER FI | | | |2254 | ESTED LOOPS N | | 285K| <----- |2255 |.FILTER | | | <----- |2256 |. NESTED LOOPS OUTER | | 114K| <----- |2257 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2258 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2259 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2260 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | <----- |2261 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |2262 | LTER FI | | | |2263 | ESTED LOOPS N | | | |2264 |.NESTED LOOPS | | 1 | |2265 |. FILTER | | | |2266 |. NESTED LOOPS OUTER | | 1 | |2267 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2268 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2269 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2270 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |2271 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |2272 | BUFFER SORT | | 1 | |2273 | VIEW | | 1 | |2274 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B7F_6E3611AA | 1 | |2275 | BUFFER SORT | | 1 | |2276 | VIEW | | 1 | |2277 | ULL TABLE ACCESS F | SYS_TEMP_0FD9D9B80_6E3611AA | 1 | |2278 | BUFFER SORT | | 1 | |2279 | VIEW | | 1 | |2280 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2281 | SORT GROUP BY | | 1 | |2282 | AN MERGE JOIN CARTESI | | 799K| |2283 | IAN MERGE JOIN CARTES | | 799K| |2284 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |2285 | UNION-ALL | | | |2286 | FILTER | | | |2287 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2288 | SORT UNIQUE | | 399K| |2289 | UNION-ALL | | | |2290 | FILTER | | | |2291 | ESS BY INDEX ROWID TABLE ACC | POSITIONS | 114K| |2292 | NGE SCAN INDEX RA | POSITIONS_IDX1 | 114K| |2293 | VIEW | | 285K| |2294 | RT WINDOW SO | | 285K| |2295 | ORT WINDOW S | | 285K| |2296 | SORT WINDOW | | 285K| |2297 | ENATION CONCAT | | | |2298 | R FILTE | | | |2299 | ED LOOPS NEST | | 285K| <----- |2300 | TER FIL | | | <----- |2301 | STED LOOPS OUTER NE | | 114K| <----- |2302 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 114K| <----- |2303 |.INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2304 | NDEX RANGE SCAN I | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2305 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | | <----- |2306 | DEX RANGE SCAN IN | POSITIONS_UK | 1 | <----- |2307 | R FILTE | | | |2308 | ED LOOPS NEST | | | |2309 | TED LOOPS NES | | 1 | |2310 | LTER FI | | | |2311 | ESTED LOOPS OUTER N | | 1 | |2312 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2313 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2314 |.INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2315 | DEX UNIQUE SCAN IN | POSITIONS_PK | 1 | <----- |2316 | LE ACCESS BY INDEX ROWID TAB | POSITIONS | 1 | <----- |2317 | VIEW | | 399K| |2318 | UNION-ALL | | | |2319 | NESTED LOOPS | | 1 | |2320 | VIEW | | 1 | |2321 | FER PUSHED RANK WINDOW BUF | | 1 | |2322 | P BY SORT GROU | | 1 | |2323 | FILTER | | | |2324 | FILTER | | | |2325 | OIN HASH J | | 1 | |2326 | ACCESS BY INDEX ROWID TABLE | VEHICLE_METRICS | 6 | <----- |2327 | X RANGE SCAN INDE | VEHICLE_METRICS_IDX2 | 492 | |2328 | VIEW | METRICS_V_ELEMENT_CLASS | 224 | |2329 | UNIQUE SORT | | 224 | |2330 | ON-ALL UNI | | | |2331 | SH JOIN RIGHT OUTER HA | | 204 | |2332 | NDEX FULL SCAN I | PK_ELEMENT_AGGREGATES | 158 | |2333 | ASH JOIN H | | 204 | |2334 |.HASH JOIN | | 204 | |2335 |. INLIST ITERATOR | | | |2336 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2337 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2338 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2339 |.TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2340 | STED LOOPS NE | | 20 | |2341 | ASH JOIN H | | 765 | |2342 |.MERGE JOIN CARTESIAN | | 790 | |2343 |. INLIST ITERATOR | | | |2344 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2345 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2346 |. BUFFER SORT | | 158 | |2347 |. SORT UNIQUE | | 158 | |2348 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2349 |.TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2350 | NDEX UNIQUE SCAN I | PK_CLASSIFICATION_ELEMENTS | 1 | |2351 | ANGE SCAN INDEX R | VEHICLE_METRICS_PK | 1 | |2352 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 1 | |2353 | RANGE SCAN INDEX | POSITIONS_UK | 1 | |2354 | S BY INDEX ROWID TABLE ACCES | PRR_MAPPINGS | 1 | |2355 | E SCAN INDEX RANG | PRR_MAPPINGS_UX1 | 1 | |2356 | FILTER | | | |2357 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2358 | E SORT UNIQU | | 399K| |2359 | UNION-ALL | | | |2360 | FILTER | | | |2361 | CCESS BY INDEX ROWID TABLE A | POSITIONS | 114K| |2362 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| |2363 | VIEW | | 285K| |2364 | SORT WINDOW | | 285K| |2365 | SORT WINDOW | | 285K| |2366 | W SORT WINDO | | 285K| |2367 | ATENATION CONC | | | |2368 | TER FIL | | | |2369 | STED LOOPS NE | | 285K| <----- |2370 | ILTER F | | | <----- |2371 |.NESTED LOOPS OUTER | | 114K| <----- |2372 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2373 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2374 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2375 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | | <----- |2376 |.INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |2377 | TER FIL | | | |2378 | STED LOOPS NE | | | |2379 | ESTED LOOPS N | | 1 | |2380 |.FILTER | | | |2381 |. NESTED LOOPS OUTER | | 1 | |2382 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2383 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2384 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2385 |.INDEX UNIQUE SCAN | POSITIONS_PK | 1 | <----- |2386 | ABLE ACCESS BY INDEX ROWID T | POSITIONS | 1 | <----- |2387 | BUFFER SORT | | 1 | |2388 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |2389 | CAN INDEX UNIQUE S | PERFORMANCE_ELEMENTS_UK1 | 1 | |2390 | BUFFER SORT | | 1 | |2391 | VIEW | | 1 | |2392 | LL TABLE ACCESS FU | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2393 | SORT GROUP BY | | 194 | |2394 | AN MERGE JOIN CARTESI | | 694K| |2395 | UTER HASH JOIN RIGHT O | | 694K| |2396 | L TABLE ACCESS FUL | PRR_MAPPINGS | 599 | |2397 | HASH JOIN | | 694K| <----- |2398 | ESIAN MERGE JOIN CART | | 799K| <----- |2399 | TESIAN MERGE JOIN CAR | | 799K| |2400 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |2401 | UNION-ALL | | | |2402 | FILTER | | | |2403 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2404 | UE SORT UNIQ | | 399K| |2405 | L UNION-AL | | | |2406 | FILTER | | | |2407 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 114K| |2408 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| <----- |2409 | VIEW | | 285K| |2410 | SORT WINDOW | | 285K| |2411 | W SORT WINDO | | 285K| |2412 | OW SORT WIND | | 285K| |2413 | CATENATION CON | | | |2414 | LTER FI | | | |2415 | ESTED LOOPS N | | 285K| <----- |2416 |.FILTER | | | <----- |2417 |. NESTED LOOPS OUTER | | 114K| <----- |2418 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2419 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2420 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2421 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | <----- |2422 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |2423 | LTER FI | | | |2424 | ESTED LOOPS N | | | |2425 |.NESTED LOOPS | | 1 | |2426 |. FILTER | | | |2427 |. NESTED LOOPS OUTER | | 1 | |2428 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2429 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2430 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2431 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | <----- |2432 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | <----- |2433 | VIEW | | 399K| |2434 | UNION-ALL | | | |2435 | OPS NESTED LO | | 1 | |2436 | VIEW | | 1 | |2437 | BUFFER PUSHED RANK WINDOW | | 1 | |2438 | ROUP BY SORT G | | 1 | |2439 | R FILTE | | | |2440 | ER FILT | | | |2441 | H JOIN HAS | | 1 | |2442 | BLE ACCESS BY INDEX ROWID TA | VEHICLE_METRICS | 6 | <----- |2443 | NDEX RANGE SCAN I | VEHICLE_METRICS_IDX2 | 492 | <----- |2444 | EW VI | METRICS_V_ELEMENT_CLASS | 224 | |2445 | ORT UNIQUE S | | 224 | |2446 |.UNION-ALL | | | |2447 |. HASH JOIN RIGHT OUTER | | 204 | |2448 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2449 |. HASH JOIN | | 204 | |2450 |. HASH JOIN | | 204 | |2451 |. INLIST ITERATOR | | | |2452 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2453 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2454 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2455 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2456 |. NESTED LOOPS | | 20 | |2457 |. HASH JOIN | | 765 | |2458 |. MERGE JOIN CARTESIAN | | 790 | |2459 |. INLIST ITERATOR | | | |2460 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2461 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2462 |. BUFFER SORT | | 158 | |2463 |. SORT UNIQUE | | 158 | |2464 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2465 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2466 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |2467 | X RANGE SCAN INDE | VEHICLE_METRICS_PK | 1 | |2468 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | |2469 | EX RANGE SCAN IND | POSITIONS_UK | 1 | |2470 | CESS BY INDEX ROWID TABLE AC | PRR_MAPPINGS | 1 | |2471 | ANGE SCAN INDEX R | PRR_MAPPINGS_UX1 | 1 | |2472 | FILTER | | | |2473 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2474 | IQUE SORT UN | | 399K| |2475 | ALL UNION- | | | |2476 | R FILTE | | | |2477 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 114K| |2478 | EX RANGE SCAN IND | POSITIONS_IDX1 | 114K| |2479 | VIEW | | 285K| |2480 | OW SORT WIND | | 285K| |2481 | DOW SORT WIN | | 285K| |2482 | NDOW SORT WI | | 285K| |2483 | ONCATENATION C | | | |2484 |.FILTER | | | |2485 |. NESTED LOOPS | | 285K| <----- |2486 |. FILTER | | | <----- |2487 |. NESTED LOOPS OUTER | | 114K| |2488 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2489 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2490 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2491 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | <----- |2492 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | <----- |2493 |.FILTER | | | |2494 |. NESTED LOOPS | | | |2495 |. NESTED LOOPS | | 1 | |2496 |. FILTER | | | |2497 |. NESTED LOOPS OUTER | | 1 | |2498 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| <----- |2499 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| <----- |2500 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | <----- |2501 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | <----- |2502 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | <----- |2503 | BUFFER SORT | | 1 | |2504 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |2505 | E SCAN INDEX UNIQU | PERFORMANCE_ELEMENTS_UK1 | 1 | |2506 | BUFFER SORT | | 1 | |2507 | VIEW | | 1 | |2508 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B81_6E3611AA | 1 |<----- |2509 | LL TABLE ACCESS FU | POSITIONS | 7266K| <----- |2510 | BUFFER SORT | | 1 | |2511 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |2512 | AN INDEX UNIQUE SC | PERFORMANCE_ELEMENTS_UK1 | 1 | |2513 | SORT GROUP BY | | 637 | |2514 | AN MERGE JOIN CARTESI | | 694K| |2515 | R NESTED LOOPS OUTE | | 694K| |2516 | HASH JOIN | | 694K|<----- |2517 | ESIAN MERGE JOIN CART | | 799K| |2518 | TESIAN MERGE JOIN CAR | | 799K| |2519 | VIEW | POSITIONS_LOOKTHROUGH | 799K| |2520 | UNION-ALL | | | |2521 | FILTER | | | |2522 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2523 | UE SORT UNIQ | | 399K| |2524 | L UNION-AL | | | |2525 | FILTER | | | |2526 | ACCESS BY INDEX ROWID TABLE | POSITIONS | 114K| |2527 | RANGE SCAN INDEX | POSITIONS_IDX1 | 114K| |2528 | VIEW | | 285K| |2529 | SORT WINDOW | | 285K| |2530 | W SORT WINDO | | 285K| |2531 | OW SORT WIND | | 285K| |2532 | CATENATION CON | | | |2533 | LTER FI | | | |2534 | ESTED LOOPS N | | 285K| |2535 |.FILTER | | | |2536 |. NESTED LOOPS OUTER | | 114K| |2537 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| |2538 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| |2539 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2540 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | | |2541 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |2542 | LTER FI | | | |2543 | ESTED LOOPS N | | | |2544 |.NESTED LOOPS | | 1 | |2545 |. FILTER | | | |2546 |. NESTED LOOPS OUTER | | 1 | |2547 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| |2548 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| |2549 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2550 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |2551 |.TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |2552 | VIEW | | 399K| |2553 | UNION-ALL | | | |2554 | OPS NESTED LO | | 1 | |2555 | VIEW | | 1 | |2556 | BUFFER PUSHED RANK WINDOW | | 1 | |2557 | ROUP BY SORT G | | 1 | |2558 | R FILTE | | | |2559 | ER FILT | | | |2560 | H JOIN HAS | | 1 | |2561 | BLE ACCESS BY INDEX ROWID TA | VEHICLE_METRICS | 6 | |2562 | NDEX RANGE SCAN I | VEHICLE_METRICS_IDX2 | 492 | |2563 | EW VI | METRICS_V_ELEMENT_CLASS | 224 | |2564 | ORT UNIQUE S | | 224 | |2565 |.UNION-ALL | | | |2566 |. HASH JOIN RIGHT OUTER | | 204 | |2567 |. INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2568 |. HASH JOIN | | 204 | |2569 |. HASH JOIN | | 204 | |2570 |. INLIST ITERATOR | | | |2571 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2572 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2573 |. INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2574 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2575 |. NESTED LOOPS | | 20 | |2576 |. HASH JOIN | | 765 | |2577 |. MERGE JOIN CARTESIAN | | 790 | |2578 |. INLIST ITERATOR | | | |2579 |. TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 5 | |2580 |. INDEX RANGE SCAN | CLASSIFICATIONS_IX1 | 5 | |2581 |. BUFFER SORT | | 158 | |2582 |. SORT UNIQUE | | 158 | |2583 |. INDEX FAST FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2584 |. TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2585 |. INDEX UNIQUE SCAN | PK_CLASSIFICATION_ELEMENTS | 1 | |2586 | X RANGE SCAN INDE | VEHICLE_METRICS_PK | 1 | |2587 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 1 | |2588 | EX RANGE SCAN IND | POSITIONS_UK | 1 | |2589 | CESS BY INDEX ROWID TABLE AC | PRR_MAPPINGS | 1 | |2590 | ANGE SCAN INDEX R | PRR_MAPPINGS_UX1 | 1 | |2591 | FILTER | | | |2592 | VIEW | POSITIONS_LOOKTHROUGH_BAS | 399K| |2593 | IQUE SORT UN | | 399K| |2594 | ALL UNION- | | | |2595 | R FILTE | | | |2596 | E ACCESS BY INDEX ROWID TABL | POSITIONS | 114K| |2597 | EX RANGE SCAN IND | POSITIONS_IDX1 | 114K| |2598 | VIEW | | 285K| |2599 | OW SORT WIND | | 285K| |2600 | DOW SORT WIN | | 285K| |2601 | NDOW SORT WI | | 285K| |2602 | ONCATENATION C | | | |2603 |.FILTER | | | |2604 |. NESTED LOOPS | | 285K| |2605 |. FILTER | | | |2606 |. NESTED LOOPS OUTER | | 114K| |2607 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| |2608 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| |2609 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2610 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | | |2611 |. INDEX RANGE SCAN | POSITIONS_UK | 1 | |2612 |.FILTER | | | |2613 |. NESTED LOOPS | | | |2614 |. NESTED LOOPS | | 1 | |2615 |. FILTER | | | |2616 |. NESTED LOOPS OUTER | | 1 | |2617 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 114K| |2618 |. INDEX RANGE SCAN | POSITIONS_IDX1 | 114K| |2619 |. INDEX RANGE SCAN | VEHICLE_RELATIONSHIPS_UK1 | 1 | |2620 |. INDEX UNIQUE SCAN | POSITIONS_PK | 1 | |2621 |. TABLE ACCESS BY INDEX ROWID | POSITIONS | 1 | |2622 | BUFFER SORT | | 1 | |2623 | BY INDEX ROWID TABLE ACCESS | PERFORMANCE_ELEMENTS | 1 | |2624 | E SCAN INDEX UNIQU | PERFORMANCE_ELEMENTS_UK1 | 1 | |2625 | BUFFER SORT | | 1 | |2626 | VIEW | | 1 | |2627 | FULL TABLE ACCESS | SYS_TEMP_0FD9D9B81_6E3611AA | 1 | |2628 | LL TABLE ACCESS FU | POSITIONS | 7266K| |2629 | VIEW | | 1 | |2630 | INDEX ROWID TABLE ACCESS BY | PRR_MAPPINGS | 1 | |2631 | AN INDEX RANGE SC | PRR_MAPPINGS_UX1 | 1 | |2632 | BUFFER SORT | | 1 | |2633 | INDEX ROWID TABLE ACCESS BY | PERFORMANCE_ELEMENTS | 1 | |2634 | AN INDEX UNIQUE SC | PERFORMANCE_ELEMENTS_UK1 | 1 | |2635 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | |2636 | MERGE JOIN CARTESIAN | | 1 | |2637 | NESTED LOOPS | | | |2638 | NESTED LOOPS | | 1 | |2639 | NESTED LOOPS | | 1 | |2640 | NESTED LOOPS | | 1 | |2641 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | |2642 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | |2643 | VIEW | | 1 | |2644 | WINDOW BUFFER PUSHED RANK | | 1 | |2645 | SORT GROUP BY | | 1 | |2646 | FILTER | | | |2647 | FILTER | | | |2648 | HASH JOIN | | 11 | |2649 | ROWID TABLE ACCESS BY INDEX | VEHICLE_METRICS | 6 | |2650 | INDEX RANGE SCAN | VEHICLE_METRICS_IDX2 | 492 | |2651 | VIEW | METRICS_V_ELEMENT_CLASS | 2090 | |2652 | SORT UNIQUE | | 2090 | |2653 | UNION-ALL | | | |2654 | TER HASH JOIN RIGHT OU | | 2078 | |2655 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2656 | HASH JOIN | | 2078 | |2657 | L TABLE ACCESS FUL | PERFORMANCE_ELEMENTS | 1863 | |2658 | HASH JOIN | | 2078 | |2659 | LL TABLE ACCESS FU | CLASSIFICATIONS | 51 | |2660 | SCAN INDEX FAST FULL | PK_CLASSIFICATION_ELEMENTS | 2078 | |2661 | HASH JOIN | | 12 | |2662 | HASH JOIN | | 12 | |2663 | SEMI HASH JOIN RIGHT | | 9 | |2664 | INDEX FULL SCAN | PK_ELEMENT_AGGREGATES | 158 | |2665 | LL TABLE ACCESS FU | PERFORMANCE_ELEMENTS | 1863 | |2666 | SCAN INDEX FAST FULL | PK_CLASSIFICATION_ELEMENTS | 2078 | |2667 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |2668 | INDEX RANGE SCAN | VEHICLE_METRICS_PK | 1 | |2669 | OWID TABLE ACCESS BY INDEX R | POSITIONS | 1 | |2670 | INDEX RANGE SCAN | POSITIONS_UK | 1 | |2671 | TABLE ACCESS BY INDEX ROWID | CLASSIFICATIONS | 1 | |2672 | INDEX UNIQUE SCAN | CLASSIFICATIONS_PK | 1 | |2673 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_PK | 1 | |2674 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | |2675 | BUFFER SORT | | 1 | |2676 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | |2677 | INDEX RANGE SCAN | PERFORMANCE_ELEMENTS_IX2 | 1 | |2678 | HASH GROUP BY | | 42 | |2679 | FILTER | | | |2680 | VIEW | | 42 | |2681 | UNION-ALL | | | |2682 | NESTED LOOPS | | 1 | |2683 | NESTED LOOPS | | 1 | |2684 | VIEW | | 50 | |2685 | WINDOW SORT PUSHED RANK | | 50 | |2686 | FILTER | | | |2687 | D TABLE ACCESS BY INDEX ROWI | VALUATIONS | 50 | |2688 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | |2689 | TABLE ACCESS BY INDEX ROWID | PRR_MAPPINGS | 1 | |2690 | INDEX RANGE SCAN | PRR_MAPPINGS_UX1 | 1 | |2691 | TCH COLLECTION ITERATOR PICKLER FE | GET_METRICS_ALLOC_CONTRIBS_BAS | | |2692 | NESTED LOOPS | | 41 | |2693 | VIEW | | 50 | |2694 | WINDOW SORT PUSHED RANK | | 50 | |2695 | FILTER | | | |2696 | TABLE ACCESS BY INDEX ROWID | VALUATIONS | 50 | |2697 | INDEX RANGE SCAN | VALUATIONS_IDX2 | 50 | |2698 | TCH COLLECTION ITERATOR PICKLER FE | GET_METRICS_ALLOC_CONTRIBS_BAS | | |2699 | TABLE ACCESS BY INDEX ROWID | PERFORMANCE_ELEMENTS | 1 | |2700 | INDEX UNIQUE SCAN | PERFORMANCE_ELEMENTS_PK | 1 | |2701 | TABLE ACCESS BY INDEX ROWID | VEHICLES | 1 | |2702 | INDEX UNIQUE SCAN | VEHICLE_PK | 1 | |2703 | VIEW | RPT_VEHICLE_P_E_SORT_ORDERS | 4158 | |2704 | SORT ORDER BY | | 4158 | |2705 | UNION-ALL | | | |2706 | WINDOW SORT | | 2 | |2707 | HASH GROUP BY | | 2 | |2708 | CONCATENATION | | | |2709 | FILTER | | | |2710 | HASH JOIN | | 9676M| |2711 | VIEW | PERFORMANCE_ELEMENTS_SORT | 4156 | |2712 | WINDOW SORT | | 4156 | |2713 | HASH JOIN | | 4156 | |2714 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2715 | HASH JOIN | | 4156 | |2716 | HASH JOIN | | 102 | |2717 | MERGE JOIN CARTESIAN | | 10 | |2718 | VIEW | | 2 | |2719 | UNION-ALL | | | |2720 | FILTER | | | |2721 | FAST DUAL | | 1 | |2722 | FILTER | | | |2723 | FAST DUAL | | 1 | |2724 | BUFFER SORT | | 5 | |2725 | INDEX FAST FULL SCAN | PK_REPORT_CONTEXTS | 5 | |2726 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |2727 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2728 | NESTED LOOPS | | 1089G| |2729 | MERGE JOIN CARTESIAN | | 133M| |2730 | NESTED LOOPS | | 66M| |2731 | HASH JOIN | | 8168 | |2732 | NESTED LOOPS | | 8168 | |2733 | INDEX UNIQUE SCAN | PK_RPT_REPORT_CONTROL | 1 | |2734 | COLLECTION ITERATOR PICKLER FETCH | GET_RPT_REPORT_ATTRIBUTES | | |2735 | TABLE ACCESS FULL | VEHICLES | 10304 | |2736 | COLLECTION ITERATOR PICKLER FETCH | GET_RPT_REPORT_FLAGS | | |2737 | BUFFER SORT | | 2 | |2738 | VIEW | | 2 | |2739 | UNION-ALL | | | |2740 | FILTER | | | |2741 | FAST DUAL | | 1 | |2742 | FILTER | | | |2743 | FAST DUAL | | 1 | |2744 | COLLECTION ITERATOR PICKLER FETCH | GET_METRICS_ALLOC_CONTRIBS | | |2745 | FILTER | | | |2746 | HASH JOIN | | 9676M| |2747 | VIEW | PERFORMANCE_ELEMENTS_SORT | 4156 | |2748 | WINDOW SORT | | 4156 | |2749 | HASH JOIN | | 4156 | |2750 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2751 | HASH JOIN | | 4156 | |2752 | HASH JOIN | | 102 | |2753 | MERGE JOIN CARTESIAN | | 10 | |2754 | VIEW | | 2 | |2755 | UNION-ALL | | | |2756 | FILTER | | | |2757 | FAST DUAL | | 1 | |2758 | FILTER | | | |2759 | FAST DUAL | | 1 | |2760 | BUFFER SORT | | 5 | |2761 | INDEX FAST FULL SCAN | PK_REPORT_CONTEXTS | 5 | |2762 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |2763 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2764 | NESTED LOOPS | | 1089G| |2765 | MERGE JOIN CARTESIAN | | 133M| |2766 | NESTED LOOPS | | 66M| |2767 | HASH JOIN | | 8168 | |2768 | NESTED LOOPS | | 8168 | |2769 | INDEX UNIQUE SCAN | PK_RPT_REPORT_CONTROL | 1 | |2770 | COLLECTION ITERATOR PICKLER FETCH | GET_RPT_REPORT_ATTRIBUTES | | |2771 | TABLE ACCESS FULL | VEHICLES | 10304 | |2772 | COLLECTION ITERATOR PICKLER FETCH | GET_RPT_REPORT_FLAGS | | |2773 | BUFFER SORT | | 2 | |2774 | VIEW | | 2 | |2775 | UNION-ALL | | | |2776 | FILTER | | | |2777 | FAST DUAL | | 1 | |2778 | FILTER | | | |2779 | FAST DUAL | | 1 | |2780 | COLLECTION ITERATOR PICKLER FETCH | GET_METRICS_ALLOC_CONTRIBS | | |2781 | HASH JOIN | | 4156 | |2782 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2783 | VIEW | PERFORMANCE_ELEMENTS_SORT | 4156 | |2784 | WINDOW SORT | | 4156 | |2785 | FILTER | | | |2786 | HASH JOIN | | 4156 | |2787 | TABLE ACCESS FULL | PERFORMANCE_ELEMENTS | 1863 | |2788 | HASH JOIN | | 4156 | |2789 | HASH JOIN | | 102 | |2790 | MERGE JOIN CARTESIAN | | 10 | |2791 | VIEW | | 2 | |2792 | UNION-ALL | | | |2793 | FILTER | | | |2794 | FAST DUAL | | 1 | |2795 | FILTER | | | |2796 | FAST DUAL | | 1 | |2797 | BUFFER SORT | | 5 | |2798 | INDEX FAST FULL SCAN | PK_REPORT_CONTEXTS | 5 | |2799 | TABLE ACCESS FULL | CLASSIFICATIONS | 51 | |2800 | INDEX FAST FULL SCAN | PK_CLASSIFICATION_ELEMENTS | 2078 | |2801 | VIEW | | 32 | |2802 | FILTER | | | |2803 | TABLE ACCESS FULL | PRR_MAPPINGS | 3812 | |2804 | TABLE ACCESS BY INDEX ROWID | VEHICLE_REPORTING_FAMILIES | 1 | |2805 | INDEX UNIQUE SCAN | PK_VEHICLE_REPORTING_FAMILIES | 1 | ----------------------------------------------------------------------------------------------------------------