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