1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Plan
SELECT STATEMENT CHOOSECost: 2,864 Bytes: 1,771 Cardinality: 23
16 SORT ORDER BY Cost: 2,864 Bytes: 1,771 Cardinality: 23
15 HASH JOIN SEMI Cost: 2,862 Bytes: 1,771 Cardinality: 23
6 HASH JOIN Cost: 1,719 Bytes: 2,566,728 Cardinality: 47,532
4 NESTED LOOPS Cost: 69 Bytes: 930,842 Cardinality: 32,098
1 INDEX FAST FULL SCAN UNIQUE SIDDWH.PK_DWH_AVENANTS Cost: 69 Bytes: 1,281,664 Cardinality: 80,104
3 INLIST ITERATOR
2 INDEX UNIQUE SCAN UNIQUE SIDDWH.PK_DWH_CONTRATS Bytes: 756,886 Cardinality: 58,222
5 TABLE ACCESS FULL SIDDWH.DWH_HISTO_PRIMES Cost: 1,463 Bytes: 7,400,875 Cardinality: 296,035
14 VIEW SYS.VW_NSO_1 Cost: 1,069 Bytes: 1,093,236 Cardinality: 47,532
13 SORT GROUP BY Cost: 1,069 Bytes: 2,376,600 Cardinality: 47,532
12 HASH JOIN Cost: 662 Bytes: 2,376,600 Cardinality: 47,532
10 NESTED LOOPS Cost: 69 Bytes: 930,842 Cardinality: 32,098
7 INDEX FAST FULL SCAN UNIQUE SIDDWH.PK_DWH_AVENANTS Cost: 69 Bytes: 1,281,664 Cardinality: 80,104
9 INLIST ITERATOR
8 INDEX UNIQUE SCAN UNIQUE SIDDWH.PK_DWH_CONTRATS Bytes: 756,886 Cardinality: 58,222
11 INDEX FAST FULL SCAN UNIQUE SIDDWH.PK_DWH_HISTO_PRIMES Cost: 424 Bytes: 6,216,735 Cardinality: 296,035 |
Partager