susah di baca explain plannya ancur formattingnya... kalau mau post di http://www.indo-oracletech.com/forum/viewforum.php?f=37 saya akan coba bantu :)
sekalian kasih info tentang: 1. Jumlah record di masing2 table 2. jumlah record di table DPP dengan unitup_skr = '11208' 3. struktur index DPP_BULAN 4. hapus hint INDEX, generate explain plannya. 2008/8/5 forum_it82 <[EMAIL PROTECTED]> > 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 > > > -- Cheers, Yoel Susanto www.indo-oracletech.com [Non-text portions of this message have been removed]
