Ver Mensaje Individual
  #11 (permalink)  
Antiguo 25/07/2011, 10:27
rcastaneda
 
Fecha de Ingreso: junio-2011
Mensajes: 16
Antigüedad: 13 años, 4 meses
Puntos: 0
Respuesta: OPTIMIZAR SELECT ORACLE 10g

----------PLAN DE EJECUCION


Plan
SELECT STATEMENT CHOOSECost: 2.309.132 Bytes: 44.178.108 Cardinality: 283.202
54 PX COORDINATOR
53 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10011 :Q1011
52 BUFFER SORT PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 2.309.132 Bytes: 44.178.108 Cardinality: 283.202
51 UNION-ALL PARALLEL_COMBINED_WITH_PARENT :Q1011
35 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 2.264.717 Bytes: 44.176.704 Cardinality: 283.184
30 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 2.256.817 Bytes: 38.229.840 Cardinality: 283.184
29 PX SEND HASH PARALLEL_TO_PARALLEL SYS.:TQ10008 :Q1008Cost: 2.256.817 Bytes: 38.229.840 Cardinality: 283.184
28 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 2.256.817 Bytes: 38.229.840 Cardinality: 283.184
4 BUFFER SORT PARALLEL_COMBINED_WITH_CHILD :Q1008
3 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 3 Bytes: 3.352 Cardinality: 419
2 PX SEND BROADCAST PARALLEL_FROM_SERIAL SYS.:TQ10001 Cost: 3 Bytes: 3.352 Cardinality: 419
1 TABLE ACCESS FULL TABLE PPGA.PPGA_TIPBONO Cost: 3 Bytes: 3.352 Cardinality: 419
27 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 2.256.814 Bytes: 35.964.368 Cardinality: 283.184
8 BUFFER SORT PARALLEL_COMBINED_WITH_CHILD :Q1008
7 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 4 Bytes: 25.536 Cardinality: 1.824
6 PX SEND BROADCAST PARALLEL_FROM_SERIAL SYS.:TQ10002 Cost: 4 Bytes: 25.536 Cardinality: 1.824
5 TABLE ACCESS FULL TABLE PPGA.PPGA_BONOS Cost: 4 Bytes: 25.536 Cardinality: 1.824
26 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 2.256.685 Bytes: 11.231.926.088 Cardinality: 99.397.576
20 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 1.835.966 Bytes: 787.930.380 Cardinality: 8.294.004
19 PX SEND HASH PARALLEL_TO_PARALLEL SYS.:TQ10006 :Q1006Cost: 1.835.966 Bytes: 787.930.380 Cardinality: 8.294.004
18 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1006Cost: 1.835.966 Bytes: 787.930.380 Cardinality: 8.294.004
12 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1006Cost: 653.239 Bytes: 240.526.116 Cardinality: 8.294.004
11 PX SEND HASH PARALLEL_TO_PARALLEL SYS.:TQ10005 :Q1005Cost: 653.239 Bytes: 240.526.116 Cardinality: 8.294.004
10 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1005Cost: 653.239 Bytes: 240.526.116 Cardinality: 8.294.004 Partition #: 24 Partitions accessed #1 - #20
9 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT PPGA.PPGA_ACTABOPRE :Q1005Cost: 653.239 Bytes: 240.526.116 Cardinality: 8.294.004 Partition #: 24 Partitions accessed #1 - #20
17 BUFFER SORT PARALLEL_COMBINED_WITH_CHILD :Q1006
16 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1006Cost: 1.174.106 Bytes: 1.397.846.010 Cardinality: 21.179.485
15 PX SEND HASH PARALLEL_FROM_SERIAL SYS.:TQ10000 Cost: 1.174.106 Bytes: 1.397.846.010 Cardinality: 21.179.485
14 PARTITION LIST ALL Cost: 1.174.106 Bytes: 1.397.846.010 Cardinality: 21.179.485 Partition #: 29 Partitions accessed #1 - #20
13 TABLE ACCESS FULL TABLE PPGA.PPGA_ADQUISICIONES Cost: 1.174.106 Bytes: 1.397.846.010 Cardinality: 21.179.485 Partition #: 29 Partitions accessed #1 - #20
25 BUFFER SORT PARALLEL_COMBINED_WITH_CHILD :Q1008
24 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1008Cost: 386.729 Bytes: 4.136.023.926 Cardinality: 229.779.107
23 PX SEND HASH PARALLEL_FROM_SERIAL SYS.:TQ10003 Cost: 386.729 Bytes: 4.136.023.926 Cardinality: 229.779.107
22 PARTITION LIST ALL Cost: 386.729 Bytes: 4.136.023.926 Cardinality: 229.779.107 Partition #: 34 Partitions accessed #1 - #20
21 TABLE ACCESS FULL TABLE PPGA.PPGA_BONOPRE Cost: 386.729 Bytes: 4.136.023.926 Cardinality: 229.779.107 Partition #: 34 Partitions accessed #1 - #20
34 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 7.869 Bytes: 494.031.825 Cardinality: 23.525.325
33 PX SEND HASH PARALLEL_TO_PARALLEL SYS.:TQ10009 :Q1009Cost: 7.869 Bytes: 494.031.825 Cardinality: 23.525.325
32 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1009Cost: 7.869 Bytes: 494.031.825 Cardinality: 23.525.325 Partition #: 38 Partitions accessed #1 - #20
31 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT PPGA.PPGA_ABOPREPCOM :Q1009Cost: 7.869 Bytes: 494.031.825 Cardinality: 23.525.325 Partition #: 38 Partitions accessed #1 - #20
50 FILTER PARALLEL_COMBINED_WITH_CHILD :Q1011
49 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 44.416 Bytes: 1.404 Cardinality: 18
46 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1011Cost: 36.438 Bytes: 1.134 Cardinality: 21
45 PX SEND BROADCAST LOCAL PARALLEL_TO_PARALLEL SYS.:TQ10010 :Q1010Cost: 36.438 Bytes: 1.134 Cardinality: 21
44 HASH JOIN PARALLEL_COMBINED_WITH_PARENT :Q1010Cost: 36.438 Bytes: 1.134 Cardinality: 21
39 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1010Cost: 36.435 Bytes: 924 Cardinality: 21
38 PX SEND HASH PARALLEL_TO_PARALLEL SYS.:TQ10007 :Q1007Cost: 36.435 Bytes: 924 Cardinality: 21
37 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1007Cost: 36.435 Bytes: 924 Cardinality: 21 Partition #: 47 Partitions accessed #1 - #20
36 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT PPGA.PPGA_BONOPRE :Q1007Cost: 36.435 Bytes: 924 Cardinality: 21 Partition #: 47 Partitions accessed #1 - #20
43 BUFFER SORT PARALLEL_COMBINED_WITH_CHILD :Q1010
42 PX RECEIVE PARALLEL_COMBINED_WITH_PARENT :Q1010Cost: 3 Bytes: 4.190 Cardinality: 419
41 PX SEND HASH PARALLEL_FROM_SERIAL SYS.:TQ10004 Cost: 3 Bytes: 4.190 Cardinality: 419
40 TABLE ACCESS FULL TABLE PPGA.PPGA_TIPBONO Cost: 3 Bytes: 4.190 Cardinality: 419
48 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1011Cost: 7.947 Bytes: 564.607.800 Cardinality: 23.525.325 Partition #: 53 Partitions accessed #1 - #20
47 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT PPGA.PPGA_ABOPREPCOM :Q1011Cost: 7.947 Bytes: 564.607.800 Cardinality: 23.525.325 Partition #: 53 Partitions accessed #1 - #20