Ca choque qq'un ce plan d'execution !!!

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
 
 
Plan
SELECT STATEMENT CHOOSE Cost: 934,076 Bytes: 134 Cardinality: 1 
 31 HASH GROUP BY Cost: 934,076 Bytes: 134 Cardinality: 1 
  30 NESTED LOOPS Cost: 934,075 Bytes: 134 Cardinality: 1 
   27 HASH JOIN Cost: 934,074 Bytes: 122 Cardinality: 1 
     25 HASH JOIN Cost: 934,031 Bytes: 103 Cardinality: 1 
        10 VIEW VIEW PIC.V_NBJOURNAUX Cost: 196,422 Bytes: 14,280 Cardinality: 476 
	         9 HASH GROUP BY Cost: 196,422 Bytes: 9,520 Cardinality: 476 
             8 VIEW PIC. Cost: 196,421 Bytes: 9,520 Cardinality: 476 
               7 HASH UNIQUE Cost: 196,421 Bytes: 28,084 Cardinality: 476 
                 6 NESTED LOOPS Cost: 196,420 Bytes: 28,084 Cardinality: 476 
                    3 INLIST ITERATOR 
                      2 TABLE ACCESS BY INDEX ROWID TABLE PIC.DET_COMMANDE Cost: 103,404 Bytes: 1,229,254 Cardinality: 47,279 
                        1 INDEX RANGE SCAN INDEX PIC.I_DATCOM Cost: 85,154 Cardinality: 46,337 
                    5 TABLE ACCESS BY INDEX ROWID TABLE PIC.TOT_COMMANDE Cost: 2 Bytes: 33 Cardinality: 1 
                      4 INDEX UNIQUE SCAN INDEX (UNIQUE) PIC.PK_ TOT_COMMANDE Cost: 1 Cardinality: 1 
          24 VIEW VIEW PIC.V_CALCULEMPL Cost: 737,601 Bytes: 14,022,862 Cardinality: 192,094 
            23 UNION-ALL 
              17 HASH JOIN Cost: 725,950 Bytes: 16,005,612 Cardinality: 190,543 
                15 HASH JOIN Cost: 458,260 Bytes: 10,590,496 Cardinality: 189,116 
                  13 INLIST ITERATOR 
                    12 TABLE ACCESS BY INDEX ROWID TABLE PIC. DET_COMMANDE Cost: 157,887 Bytes: 6,997,292 Cardinality: 189,116 
                      11 INDEX RANGE SCAN INDEX PIC.I_DATCOM Cost: 84,887 Cardinality: 185,348 
                  14 INDEX FAST FULL SCAN INDEX PIC.I_DATCOM2 Cost: 139,346 Bytes: 394,538,800 Cardinality: 20,765,200 
                16 TABLE ACCESS FULL TABLE PIC.TOT_COMMANDE Cost: 117,953 Bytes: 416,948,336 Cardinality: 14,891,012 
              20 HASH JOIN Cost: 835 Bytes: 44,044 Cardinality: 1,001 
                18 TABLE ACCESS FULL TABLE PIC.TREMISE Cost: 597 Bytes: 33,033 Cardinality: 1,001 
                19 TABLE ACCESS FULL TABLE PIC. TDETREMISE Cost: 235 Bytes: 660,440 Cardinality: 60,040 
            22 HASH GROUP BY Cost: 10,816 Bytes: 18,150 Cardinality: 550 
                21 TABLE ACCESS FULL TABLE PIC.TREPCLIENT Cost: 10,815 Bytes: 18,150 Cardinality: 550 
        26 TABLE ACCESS FULL TABLE PIC.TCALIEUJOUR Cost: 43 Bytes: 3,629 Cardinality: 191 
      29 TABLE ACCESS BY INDEX ROWID TABLE PIC.TLIEU Cost: 1 Bytes: 12 Cardinality: 1 
        28 INDEX UNIQUE SCAN INDEX (UNIQUE) PIC.PK_TLIEU Cost: 0 Cardinality: 1