[indo-oracle] optimasi query insert into...helppp

[forum_it82]

Rekan sekalian,

Mohon bantuannya..
bagaimana caranya query ini bisa lebih cepat??
karena saya jalankan query ini, waktu yang dibutuhkan lama sekali
(kira2 sampe 2 jam/lebih)

/* Formatted on 2008/08/05 22:46 (Formatter Plus v4.8.7) */
INSERT INTO dpp_080805222721
   SELECT /*+ INDEX(A DPP_BULAN) */
          *
     FROM dpp a
    WHERE unitup_skr = '11208'
      AND NOT EXISTS (
             SELECT 1
               FROM dph_sementara b
              WHERE a.idpel = b.idpel
                AND a.bulan = b.bulan
                AND a.kdpembpp = b.kdpembpp
                AND b.id_anjak IS NULL)
      AND NOT EXISTS (
             SELECT 1
               FROM dph b
              WHERE a.idpel = b.idpel
                AND a.bulan = b.bulan
                AND a.kdpembpp = b.kdpembpp
                AND b.id_anjak IS NULL)



EXPLAIN PLAN

Operation       Object Name     Rows    Bytes   Cost    Object Node     In/Out  
PStart  PStop

INSERT STATEMENT Optimizer Mode=ALL_ROWS                1 M             
4349000.21495121                
                         
Operation       Object Name     Rows    Bytes   Cost    Object Node     In/Out  
PStart  PStop
  FILTER                                                                        
 
    PARTITION HASH ALL          1 M     656 M   251641.499342193                
             
      1 20
      TABLE ACCESS BY LOCAL INDEX ROWID TKN.DPP 1 M     656 M
251641.499342193                                    1   20
        BITMAP CONVERSION TO ROWIDS                                             
                         
          BITMAP INDEX RANGE SCAN       TKN.DPP_BULAN                           
                     
      1 20
    TABLE ACCESS BY INDEX ROWID TKN.DPH_SEMENTARA       1       55  
1.00140839118856                                         
      INDEX UNIQUE SCAN TKN.PK_DPH      1               1.00133011080513        
                
                 
    TABLE ACCESS BY INDEX ROWID TKN.DPH 1       24      3.00272192497131        
 
                         
      INDEX UNIQUE SCAN TKN.PK_DPHHISTO 1               2.00198595675081        
        
                         

thanks b4