1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
SELECT STATEMENT ALL_ROWSCost: 13,090 Bytes: 22,862,909 Cardinality: 70,783
96 FILTER
18 HASH JOIN RIGHT SEMI Cost: 13,090 Bytes: 86,304,631 Cardinality: 267,197
3 PARTITION LIST SINGLE Cost: 1,670 Bytes: 8,222,794 Cardinality: 115,814 Partition #: 3 Partitions accessed #2
2 PARTITION LIST SINGLE Cost: 1,670 Bytes: 8,222,794 Cardinality: 115,814 Partition #: 4
1 TABLE ACCESS FULL TABLE DRS.DRS_FAITS_INCD_BL Cost: 1,670 Bytes: 8,222,794 Cardinality: 115,814 Partition #: 5 Partitions accessed #26
17 HASH JOIN Cost: 9,422 Bytes: 136,882,872 Cardinality: 543,186
13 PART JOIN FILTER CREATE SYS.:BF0000 Cost: 5,690 Bytes: 16,622,775 Cardinality: 85,245
12 HASH JOIN Cost: 5,690 Bytes: 16,622,775 Cardinality: 85,245
8 HASH JOIN Cost: 3,757 Bytes: 21,355,012 Cardinality: 155,876
5 PARTITION LIST SINGLE Cost: 16 Bytes: 18,124 Cardinality: 197 Partition #: 10 Partitions accessed #2
4 TABLE ACCESS FULL TABLE RDWH.HIERARCHIE Cost: 16 Bytes: 18,124 Cardinality: 197 Partition #: 11 Partitions accessed #2
7 PARTITION LIST SINGLE Cost: 3,666 Bytes: 99,003,600 Cardinality: 2,200,080 Partition #: 12 Partitions accessed #2
6 TABLE ACCESS FULL TABLE DCL.DCL_PROFIL_ENT_TIT Cost: 3,666 Bytes: 99,003,600 Cardinality: 2,200,080 Partition #: 13 Partitions accessed #2
11 PARTITION LIST SINGLE Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 14 Partitions accessed #2
10 PARTITION LIST SINGLE Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 15
9 INDEX FAST FULL SCAN INDEX DRS.PK_DRS_FAITS_ET_SRF_FNN Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 16 Partitions accessed #26
16 PARTITION LIST SINGLE Cost: 1,665 Bytes: 110,344,305 Cardinality: 1,935,865 Partition #: 17 Partitions accessed #2
15 PARTITION LIST SINGLE Cost: 1,665 Bytes: 110,344,305 Cardinality: 1,935,865 Partition #: 18 Partitions accessed #KEY(AP)
14 TABLE ACCESS FULL TABLE DRS.DRS_FAITS_INCD_BL Cost: 1,665 Bytes: 110,344,305 Cardinality: 1,935,865 Partition #: 19 Partitions accessed #26
22 PARTITION LIST SINGLE Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 20 Partitions accessed #2
21 PARTITION LIST SINGLE Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 21
20 TABLE ACCESS BY LOCAL INDEX ROWID TABLE DRS.DRS_FAITS_INCD_BL Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 22 Partitions accessed #26
19 INDEX RANGE SCAN INDEX DRS.PK_DRS_FAITS_INCD_BL Cost: 3 Cardinality: 1 Partition #: 23 Partitions accessed #26
26 PARTITION LIST SINGLE Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 24 Partitions accessed #2
25 PARTITION LIST SINGLE Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 25
24 TABLE ACCESS BY LOCAL INDEX ROWID TABLE DRS.DRS_FAITS_INCD_BL Cost: 21 Bytes: 71 Cardinality: 1 Partition #: 26 Partitions accessed #26
23 INDEX RANGE SCAN INDEX DRS.PK_DRS_FAITS_INCD_BL Cost: 3 Cardinality: 1 Partition #: 27 Partitions accessed #26
42 FILTER
41 HASH GROUP BY Cost: 4,617 Bytes: 323 Cardinality: 1
40 HASH JOIN Cost: 4,616 Bytes: 323 Cardinality: 1
38 FILTER
37 HASH JOIN OUTER Cost: 4,612 Bytes: 257 Cardinality: 1
33 HASH JOIN Cost: 2,844 Bytes: 10,153,975 Cardinality: 51,025
29 PARTITION LIST SINGLE Cost: 1,665 Bytes: 1,439,502 Cardinality: 16,546 Partition #: 34 Partitions accessed #2
28 PARTITION LIST SINGLE Cost: 1,665 Bytes: 1,439,502 Cardinality: 16,546 Partition #: 35
27 TABLE ACCESS FULL TABLE DRS.DRS_FAITS_INCD_BL Cost: 1,665 Bytes: 1,439,502 Cardinality: 16,546 Partition #: 36 Partitions accessed #26
32 PARTITION LIST SINGLE Cost: 1,130 Bytes: 157,477,600 Cardinality: 1,406,050 Partition #: 37 Partitions accessed #2
31 PARTITION LIST SINGLE Cost: 1,130 Bytes: 157,477,600 Cardinality: 1,406,050 Partition #: 38
30 TABLE ACCESS FULL TABLE DRS.DRS_BL Cost: 1,130 Bytes: 157,477,600 Cardinality: 1,406,050 Partition #: 39 Partitions accessed #126
36 PARTITION LIST SINGLE Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 40 Partitions accessed #2
35 PARTITION LIST SINGLE Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 41
34 INDEX FAST FULL SCAN INDEX DRS.PK_DRS_FAITS_SRF_FNN Cost: 471 Bytes: 69,784,440 Cardinality: 1,203,180 Partition #: 42 Partitions accessed #26
39 TABLE ACCESS FULL TABLE DRS.SUIV_RISQ .. |
Partager