******************** Plan when optimizer_adaptive_reporting_only was FALSE****************** Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 2 Session : XXXXX (509:27860) SQL ID : 8t19y7v5j9ztg SQL Execution ID : 33554432 Execution Started : 10/07/2021 07:56:09 First Refresh Time : 10/07/2021 07:56:09 Last Refresh Time : 10/07/2021 08:07:17 Duration : 668s Module/Action : SQL*Plus/- Service : XXXXX.XXXXX.com Program : sqlplus.exe Fetch Calls : 370 Global Stats ========================================================================================================================== | Elapsed | Cpu | IO | Concurrency | Cluster | Fetch | Buffer | Read | Read | Write | Write | Offload | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Reqs | Bytes | Returned Bytes | ========================================================================================================================== | 705 | 280 | 270 | 0.00 | 155 | 370 | 40M | 984K | 11GB | 6422 | 3GB | 6GB | ========================================================================================================================== SQL Plan Monitoring Details (Plan Hash Value=3015036808) ==================================================================================================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) | ==================================================================================================================================================================================================================================== | 0 | SELECT STATEMENT | | | | 512 | +157 | 1 | 2M | | | | | . | . | | | | 1 | FILTER | | | | 512 | +157 | 1 | 2M | | | | | . | . | | | | 2 | NESTED LOOPS OUTER | | 1 | 3M | 512 | +157 | 1 | 2M | | | | | . | . | | | | 3 | NESTED LOOPS OUTER | | 1 | 3M | 512 | +157 | 1 | 2M | | | | | . | . | | | | 4 | HASH JOIN OUTER | | 1 | 3M | 538 | +131 | 1 | 2M | 3387 | 2GB | 3387 | 2GB | 450MB | 2GB | | | | 5 | NESTED LOOPS OUTER | | 1 | 3M | 27 | +131 | 1 | 2M | | | | | . | . | | | | 6 | STATISTICS COLLECTOR | | | | 27 | +131 | 1 | 2M | | | | | . | . | | | | 7 | NESTED LOOPS OUTER | | 1 | 3M | 27 | +131 | 1 | 2M | | | | | . | . | | | | 8 | HASH JOIN OUTER | | 1 | 3M | 155 | +3 | 1 | 2M | 3035 | 1GB | 3035 | 1GB | 309MB | 1GB | | | | 9 | NESTED LOOPS OUTER | | 1 | 3M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 10 | STATISTICS COLLECTOR | | | | 129 | +3 | 1 | 2M | | | | | . | . | | | | 11 | NESTED LOOPS OUTER | | 1 | 3M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 12 | NESTED LOOPS OUTER | | 1 | 3M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 13 | NESTED LOOPS | | 272K | 2M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 14 | NESTED LOOPS OUTER | | 272K | 2M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 15 | NESTED LOOPS | | 272K | 2M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 16 | NESTED LOOPS OUTER | | 272K | 1M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 17 | NESTED LOOPS | | 272K | 1M | 129 | +3 | 1 | 2M | | | | | . | . | | | | 18 | FILTER | | | | 129 | +3 | 1 | 2M | | | | | . | . | | | | 19 | NESTED LOOPS OUTER | | 272K | 598K | 129 | +3 | 1 | 2M | | | | | . | . | | | | 20 | VIEW | index$_join$_006 | 276K | 48299 | 129 | +3 | 1 | 2M | | | | | . | . | | | | 21 | HASH JOIN | | | | 129 | +3 | 1 | 2M | | | | | 132MB | . | | | | 22 | HASH JOIN | | | | 3 | +1 | 1 | 2M | | | | | 124MB | . | | | | 23 | INDEX STORAGE FAST FULL SCAN | TET_IX2 | 276K | 8505 | 1 | +1 | 1 | 2M | 129 | 54MB | | | . | . | | | | 24 | INDEX STORAGE FAST FULL SCAN | TET_IX4 | 276K | 13077 | 3 | +1 | 1 | 2M | 167 | 81MB | | | . | . | | | | 25 | INDEX STORAGE FAST FULL SCAN | TET_PK | 276K | 11889 | 129 | +3 | 1 | 2M | 198 | 61MB | | | . | . | | | | 26 | TABLE ACCESS BY INDEX ROWID | TT | 1 | 2 | 129 | +3 | 2M | 2M | 1488 | 12MB | | | . | . | | | | 27 | INDEX UNIQUE SCAN | TT_PK | 1 | 1 | 129 | +3 | 2M | 2M | 7 | 57344 | | | . | . | | | | 28 | TABLE ACCESS BY INDEX ROWID | TM | 1 | 2 | 129 | +3 | 2M | 2M | 9875 | 77MB | | | . | . | | | | 29 | INDEX UNIQUE SCAN | TM_PK | 1 | 1 | 129 | +3 | 2M | 2M | 1235 | 10MB | | | . | . | | | | 30 | TABLE ACCESS BY INDEX ROWID | TU | 1 | 1 | 119 | +11 | 2M | 17764 | | | | | . | . | | | | 31 | INDEX UNIQUE SCAN | TU_PK | 1 | | 119 | +11 | 2M | 17764 | | | | | . | . | | | | 32 | TABLE ACCESS BY INDEX ROWID | TEP | 1 | 2 | 129 | +3 | 2M | 2M | 140K | 1GB | | | . | . | | | | 33 | INDEX UNIQUE SCAN | TEP_PK | 1 | 1 | 129 | +3 | 2M | 2M | 1478 | 12MB | | | . | . | | | | 34 | TABLE ACCESS BY INDEX ROWID | TLIM | 1 | 1 | 129 | +3 | 2M | 2M | | | | | . | . | | | | 35 | INDEX UNIQUE SCAN | TLIM_PK | 1 | | 129 | +3 | 2M | 2M | | | | | . | . | | | | 36 | TABLE ACCESS BY INDEX ROWID | TLPSE | 1 | 1 | 129 | +3 | 2M | 2M | | | | | . | . | | | | 37 | INDEX UNIQUE SCAN | TLPSE_PK | 1 | | 129 | +3 | 2M | 2M | | | | | . | . | | | | 38 | INDEX RANGE SCAN | TCX_IX2 | 1 | 2 | 129 | +3 | 2M | 2M | 4642 | 36MB | | | . | . | | | | 39 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 129 | +3 | 2M | 2M | 22307 | 174MB | | | . | . | | | | 40 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 129 | +3 | 2M | 2M | 546 | 4MB | | | . | . | | | | 41 | INDEX RANGE SCAN | TCX_PK | 1 | 2 | | | | | | | | | . | . | | | | 42 | INDEX RANGE SCAN | TCX_PK | 1 | 2 | 1 | +131 | 1 | 976K | | | | | . | . | | | | 43 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 27 | +131 | 2M | 2M | 21549 | 168MB | | | . | . | | | | 44 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 27 | +131 | 2M | 2M | 959 | 7MB | | | . | . | | | | 45 | TABLE ACCESS BY INDEX ROWID BATCHED | TP | 1 | 3 | | | | | | | | | . | . | | | | 46 | INDEX RANGE SCAN | TP_PK | 15 | 1 | | | | | | | | | . | . | | | | 47 | TABLE ACCESS BY INDEX ROWID BATCHED | TP | 1 | 3 | 36 | +157 | 1 | 15 | | | | | . | . | | | | 48 | INDEX RANGE SCAN | TP_PK | 15 | 1 | 36 | +157 | 1 | 15 | | | | | . | . | | | | 49 | TABLE ACCESS STORAGE FULL FIRST ROWS | TLIET | 1 | 3 | 512 | +157 | 2M | 2M | | | | | . | . | | | | 50 | VIEW PUSHED PREDICATE | TEB_VW | 1 | 57 | 506 | +163 | 2M | 1459 | | | | | . | . | | | | 51 | NESTED LOOPS OUTER | | 1 | 57 | 506 | +163 | 2M | 1459 | | | | | . | . | | | | 52 | NESTED LOOPS | | 1 | 55 | 506 | +163 | 2M | 1459 | | | | | . | . | | | | 53 | NESTED LOOPS | | 1 | 53 | 506 | +163 | 2M | 1459 | | | | | . | . | | | | 54 | NESTED LOOPS | | 1 | 51 | 506 | +163 | 2M | 1459 | | | | | . | . | | | | 55 | NESTED LOOPS | | 5 | 41 | 510 | +159 | 2M | 6965 | | | | | . | . | | | | 56 | NESTED LOOPS | | 1 | 7 | 510 | +159 | 2M | 770K | | | | | . | . | | | | 57 | NESTED LOOPS | | 1 | 4 | 510 | +159 | 2M | 770K | | | | | . | . | | | | 58 | NESTED LOOPS | | 1 | 3 | 510 | +159 | 2M | 770K | | | | | . | . | | | | 59 | TABLE ACCESS BY INDEX ROWID | TEP | 1 | 3 | 512 | +157 | 2M | 770K | 661K | 5GB | | | . | . | | | | 60 | INDEX UNIQUE SCAN | TEP_PK | 1 | 2 | 512 | +157 | 2M | 2M | 2934 | 23MB | | | . | . | | | | 61 | INDEX RANGE SCAN | TLP_IX1 | 1 | | 510 | +159 | 770K | 770K | | | | | . | . | | | | 62 | VIEW | | 1 | 1 | 510 | +159 | 770K | 770K | | | | | . | . | | | | 63 | SORT AGGREGATE | | 1 | | 510 | +159 | 770K | 770K | | | | | . | . | | | | 64 | TABLE ACCESS BY INDEX ROWID | TPR | 1 | 1 | 510 | +159 | 770K | 770K | | | | | . | . | | | | 65 | INDEX UNIQUE SCAN | TPR_PK | 1 | | 510 | +159 | 770K | 770K | | | | | . | . | | | | 66 | TABLE ACCESS BY INDEX ROWID BATCHED | TET | 1 | 3 | 511 | +158 | 770K | 770K | 79759 | 623MB | | | . | . | | | | 67 | INDEX RANGE SCAN | TET_Ix1 | 1 | 2 | 510 | +159 | 770K | 899K | 15834 | 124MB | | | . | . | | | | 68 | TABLE ACCESS BY INDEX ROWID BATCHED | TWE | 5 | 34 | 506 | +163 | 770K | 6965 | 2080 | 16MB | | | . | . | | | | 69 | INDEX RANGE SCAN | TWE_IDX1 | 35 | 2 | 506 | +163 | 770K | 6965 | 118 | 944KB | | | . | . | | | | 70 | TABLE ACCESS BY INDEX ROWID | TT | 1 | 2 | 506 | +163 | 6965 | 1459 | 208 | 2MB | | | . | . | | | | 71 | INDEX UNIQUE SCAN | TT_PK | 1 | 1 | 506 | +163 | 6965 | 6965 | | | | | . | . | | | | 72 | INDEX RANGE SCAN | TCX_IX2 | 1 | 2 | 506 | +163 | 1459 | 1459 | 1388 | 11MB | | | . | . | | | | 73 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 506 | +163 | 1459 | 1459 | 936 | 7MB | | | . | . | | | | 74 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 506 | +163 | 1459 | 1459 | 75 | 600KB | | | . | . | | | | 75 | TABLE ACCESS BY INDEX ROWID BATCHED | TLS | 1 | 2 | 506 | +163 | 1459 | 1451 | 1 | 8192 | | | . | . | | | | 76 | INDEX SKIP SCAN | TLS_PK | 1 | 1 | 506 | +163 | 1459 | 1451 | 1 | 8192 | | | . | . | | | | 77 | SORT AGGREGATE | | 1 | | 512 | +157 | 2M | 2M | | | | | . | . | | | | 78 | FIRST ROW | | 1 | 3 | 512 | +157 | 2M | 2M | | | | | . | . | | | | 79 | INDEX RANGE SCAN (MIN/MAX) | TCX_IX2 | 1 | 3 | 512 | +157 | 2M | 2M | 9356 | 73MB | | | . | . | | | ==================================================================================================================================================================================================================================== Hint Report (identified by operation id / Query Block Name / Object Alias): Total hints for statement: 3 (U - Unused (1)) --------------------------------------------------------------------------- 0 - STATEMENT U - first_rows / hint overridden by another in parent query block - first_rows 56 - SEL$5 - no_merge Note ----- - this is an adaptive plan ******************** Plan after setting optimizer_adaptive_reporting_only to TRUE****************** Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 2 Session : XXXXX (510:5394) SQL ID : 791qwn38bq6gv SQL Execution ID : 33554432 Execution Started : 10/07/2021 11:46:56 First Refresh Time : 10/07/2021 11:46:56 Last Refresh Time : 10/07/2021 11:51:36 Duration : 280s Module/Action : SQL*Plus/- Service : XXXXX.XXXXX.com Program : sqlplus.exe Fetch Calls : 370 Global Stats =========================================================================== | Elapsed | Cpu | IO | Cluster | Fetch | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | =========================================================================== | 252 | 170 | 71 | 11 | 370 | 39M | 251K | 2GB | =========================================================================== SQL Plan Monitoring Details (Plan Hash Value=250668601) ============================================================================================================================================================================================================ | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | (Max) | (%) | (# samples) | ============================================================================================================================================================================================================ | 0 | SELECT STATEMENT | | | | 279 | +2 | 1 | 2M | | | . | | | | 1 | FILTER | | | | 279 | +2 | 1 | 2M | | | . | | | | 2 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 3 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 4 | HASH JOIN OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 5 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 6 | STATISTICS COLLECTOR | | | | 279 | +2 | 1 | 2M | | | . | | | | 7 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 8 | HASH JOIN OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 9 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 10 | STATISTICS COLLECTOR | | | | 279 | +2 | 1 | 2M | | | . | | | | 11 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 12 | NESTED LOOPS OUTER | | 1 | 3M | 279 | +2 | 1 | 2M | | | . | | | | 13 | NESTED LOOPS | | 272K | 2M | 279 | +2 | 1 | 2M | | | . | | | | 14 | NESTED LOOPS OUTER | | 272K | 2M | 279 | +2 | 1 | 2M | | | . | | | | 15 | NESTED LOOPS | | 272K | 2M | 279 | +2 | 1 | 2M | | | . | | | | 16 | NESTED LOOPS OUTER | | 272K | 1M | 279 | +2 | 1 | 2M | | | . | | | | 17 | NESTED LOOPS | | 272K | 1M | 279 | +2 | 1 | 2M | | | . | | | | 18 | FILTER | | | | 279 | +2 | 1 | 2M | | | . | | | | 19 | NESTED LOOPS OUTER | | 272K | 598K | 279 | +2 | 1 | 2M | | | . | | | | 20 | VIEW | index$_join$_006 | 276K | 48299 | 279 | +2 | 1 | 2M | | | . | | | | 21 | HASH JOIN | | | | 279 | +2 | 1 | 2M | | | 132MB | | | | 22 | HASH JOIN | | | | 2 | +1 | 1 | 2M | | | 124MB | | | | 23 | INDEX STORAGE FAST FULL SCAN | TET_IX2 | 276K | 8505 | 1 | +2 | 1 | 2M | | | . | | | | 24 | INDEX STORAGE FAST FULL SCAN | TET_IX4 | 276K | 13077 | 1 | +2 | 1 | 2M | | | . | | | | 25 | INDEX STORAGE FAST FULL SCAN | TET_PK | 276K | 11889 | 279 | +2 | 1 | 2M | 149 | 62MB | . | | | | 26 | TABLE ACCESS BY INDEX ROWID | TT | 1 | 2 | 279 | +2 | 2M | 2M | 2347 | 18MB | . | | | | 27 | INDEX UNIQUE SCAN | TT_PK | 1 | 1 | 279 | +2 | 2M | 2M | 11 | 90112 | . | | | | 28 | TABLE ACCESS BY INDEX ROWID | TM | 1 | 2 | 279 | +2 | 2M | 2M | 12476 | 97MB | . | | | | 29 | INDEX UNIQUE SCAN | TM_PK | 1 | 1 | 279 | +2 | 2M | 2M | 1683 | 13MB | . | | | | 30 | TABLE ACCESS BY INDEX ROWID | TU | 1 | 1 | 257 | +21 | 2M | 17764 | 137 | 1MB | . | | | | 31 | INDEX UNIQUE SCAN | TU_PK | 1 | | 257 | +21 | 2M | 17764 | 1 | 8192 | . | | | | 32 | TABLE ACCESS BY INDEX ROWID | TEP | 1 | 2 | 279 | +2 | 2M | 2M | 155K | 1GB | . | | | | 33 | INDEX UNIQUE SCAN | TEP_PK | 1 | 1 | 279 | +2 | 2M | 2M | 1729 | 14MB | . | | | | 34 | TABLE ACCESS BY INDEX ROWID | TLIM | 1 | 1 | 279 | +2 | 2M | 2M | | | . | | | | 35 | INDEX UNIQUE SCAN | TLIM_PK | 1 | | 279 | +2 | 2M | 2M | | | . | | | | 36 | TABLE ACCESS BY INDEX ROWID | TLPSE | 1 | 1 | 279 | +2 | 2M | 2M | | | . | | | | 37 | INDEX UNIQUE SCAN | TLPSE_PK | 1 | | 279 | +2 | 2M | 2M | | | . | | | | 38 | INDEX RANGE SCAN | TCX_IX2 | 1 | 2 | 279 | +2 | 2M | 2M | 8870 | 69MB | . | | | | 39 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 279 | +2 | 2M | 2M | 14648 | 114MB | . | | | | 40 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 279 | +2 | 2M | 2M | 157 | 1MB | . | | | | 41 | INDEX RANGE SCAN | TCX_PK | 1 | 2 | 279 | +2 | 2M | 2M | | | . | | | | 42 | INDEX RANGE SCAN | TCX_PK | 1 | 2 | | | | | | | . | | | | 43 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 279 | +2 | 2M | 2M | 16037 | 125MB | . | | | | 44 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 279 | +2 | 2M | 2M | 224 | 2MB | . | | | | 45 | TABLE ACCESS BY INDEX ROWID | TP | 1 | 3 | 279 | +2 | 2M | 2M | | | . | | | | 46 | INDEX RANGE SCAN | TP_PK | 15 | 1 | 279 | +2 | 2M | 28M | | | . | | | | 47 | TABLE ACCESS BY INDEX ROWID | TP | 1 | 3 | | | | | | | . | | | | 48 | INDEX RANGE SCAN | TP_PK | 15 | 1 | | | | | | | . | | | | 49 | TABLE ACCESS STORAGE FULL FIRST ROWS | TLIET | 1 | 3 | 279 | +2 | 2M | 2M | | | . | | | | 50 | VIEW PUSHED PREDICATE | TEB_VW | 1 | 57 | 256 | +24 | 2M | 1459 | | | . | | | | 51 | NESTED LOOPS OUTER | | 1 | 57 | 272 | +8 | 2M | 1459 | | | . | | | | 52 | NESTED LOOPS | | 1 | 55 | 256 | +24 | 2M | 1459 | | | . | | | | 53 | NESTED LOOPS | | 1 | 53 | 256 | +24 | 2M | 1459 | | | . | | | | 54 | NESTED LOOPS | | 1 | 51 | 272 | +9 | 2M | 1459 | | | . | | | | 55 | NESTED LOOPS | | 5 | 41 | 279 | +2 | 2M | 6965 | | | . | | | | 56 | NESTED LOOPS | | 1 | 7 | 279 | +2 | 2M | 770K | | | . | | | | 57 | NESTED LOOPS | | 1 | 4 | 279 | +2 | 2M | 770K | | | . | | | | 58 | NESTED LOOPS | | 1 | 3 | 279 | +2 | 2M | 770K | | | . | | | | 59 | TABLE ACCESS BY INDEX ROWID | TEP | 1 | 3 | 279 | +2 | 2M | 770K | | | . | | | | 60 | INDEX UNIQUE SCAN | TEP_PK | 1 | 2 | 279 | +2 | 2M | 2M | | | . | | | | 61 | INDEX RANGE SCAN | TLP_IX1 | 1 | | 279 | +2 | 770K | 770K | | | . | | | | 62 | VIEW | | 1 | 1 | 279 | +2 | 770K | 770K | | | . | | | | 63 | SORT AGGREGATE | | 1 | | 279 | +2 | 770K | 770K | | | . | | | | 64 | TABLE ACCESS BY INDEX ROWID | TPR | 1 | 1 | 279 | +2 | 770K | 770K | | | . | | | | 65 | INDEX UNIQUE SCAN | TPR_PK | 1 | | 279 | +2 | 770K | 770K | | | . | | | | 66 | TABLE ACCESS BY INDEX ROWID | TET | 1 | 3 | 279 | +2 | 770K | 770K | 28892 | 226MB | . | | | | 67 | INDEX RANGE SCAN | TET_Ix1 | 1 | 2 | 279 | +2 | 770K | 899K | 6957 | 54MB | . | | | | 68 | TABLE ACCESS BY INDEX ROWID | TWE | 5 | 34 | 272 | +9 | 770K | 6965 | 890 | 7MB | . | | | | 69 | INDEX RANGE SCAN | TWE_IDX1 | 35 | 2 | 272 | +9 | 770K | 6965 | 22 | 176KB | . | | | | 70 | TABLE ACCESS BY INDEX ROWID | TT | 1 | 2 | 272 | +9 | 6965 | 1459 | | | . | | | | 71 | INDEX UNIQUE SCAN | TT_PK | 1 | 1 | 272 | +9 | 6965 | 6965 | | | . | | | | 72 | INDEX RANGE SCAN | TCX_IX2 | 1 | 2 | 256 | +24 | 1459 | 1459 | 932 | 7MB | . | | | | 73 | TABLE ACCESS BY INDEX ROWID | TC | 1 | 2 | 256 | +24 | 1459 | 1459 | | | . | | | | 74 | INDEX UNIQUE SCAN | TC_PK | 1 | 1 | 256 | +24 | 1459 | 1459 | | | . | | | | 75 | TABLE ACCESS BY INDEX ROWID | TLS | 1 | 2 | 256 | +24 | 1459 | 1451 | | | . | | | | 76 | INDEX SKIP SCAN | TLS_PK | 1 | 1 | 256 | +24 | 1459 | 1451 | | | . | | | | 77 | SORT AGGREGATE | | 1 | | 279 | +2 | 2M | 2M | | | . | | | | 78 | FIRST ROW | | 1 | 3 | 279 | +2 | 2M | 2M | | | . | | | | 79 | INDEX RANGE SCAN (MIN/MAX) | TCX_IX2 | 1 | 3 | 279 | +2 | 2M | 2M | | | . | | | ============================================================================================================================================================================================================ Hint Report (identified by operation id / Query Block Name / Object Alias): Total hints for statement: 3 (U - Unused (1)) --------------------------------------------------------------------------- 0 - STATEMENT U - first_rows / hint overridden by another in parent query block - first_rows 56 - SEL$5 - no_merge Note ----- - this is an adaptive plan