Btw, Tablenya di partisi ya? kalau iya, di partisi berdasarkan kolom apa? salam,
Iw ----- Original Message ---- From: forum_it82 <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, August 5, 2008 10:46:54 PM Subject: [indo-oracle] optimasi query insert into...helppp 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 ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links [Non-text portions of this message have been removed]
