Thank's ....!!!
Udah berhasil Mas !!
Saya coba ...
QDGCF> 2. select A.TGL, A.NO_TELP, B.NM_PELANGGAN, C.NM_REGU
QDGCF> from M_PELANGGAN B
QDGCF> inner join M_REGU C on B.REGU=C.KD_REGU
QDGCF> left join KONSELING A on A.NO_TELP=B.NO_TELP
QDGCF> where A.NO_TELP is null
Mohon Penjelasannya :
Tadinya :
Plan
PLAN JOIN (JOIN (B NATURAL,C INDEX (M_TELP_IDX2)),A NATURAL)
Adapted Plan
PLAN JOIN (JOIN (B NATURAL,C INDEX (M_TELP_IDX2)),A NATURAL)
Lama eksekusi 3 - 4 Menit dengan jml Data M_Regu=150, M_Pelanggan = 5000 dan
Konseling = 3000 - 4000 data
Kemudian saya tambahin Index pada Konseling :
CREATE INDEX KONSELING_IDX1 ON KONSELING (NO_TELP);
Hasilnya :
Plan
PLAN JOIN (JOIN (C NATURAL,B INDEX (M_TELP_IDX2)),A INDEX (KONSELING_IDX1))
Adapted Plan
PLAN JOIN (JOIN (C NATURAL,B INDEX (M_TELP_IDX2)),A INDEX (KONSELING_IDX1))
Hasil Eksekusi dalam <1 Detik dengan jml data yang sama,dan query
yg sama.
Pertanyaan :
1. Maksudnya PLAN JOIN(... dst .. ) tsb apa ?? dan bedanya dg Adapted
Plan di bwh nya apa ..?
2. Kenapa C masih Natural ?? padahal
udah CREATE INDEX M_REGU_IDX1 ON M_REGU (NO_REGU);
Monday, November 8, 2004, 2:39:19 PM, you wrote:
QDGCF> coba kalo ini
QDGCF> 2. select A.TGL, A.NO_TELP, B.NM_PELANGGAN, C.NM_REGU
QDGCF> from M_PELANGGAN B
QDGCF> inner join M_REGU C on B.REGU=C.KD_REGU
QDGCF> left join KONSELING A on A.NO_TELP=B.NO_TELP
QDGCF> where A.NO_TELP is null
QDGCF> 3. select A.TGL, A.NO_TELP
QDGCF> from KONSELING A
QDGCF> left join M_PELANGGAN B on A.NO_TELP=B.NO_TELP
QDGCF> where B.NO_TELP is null
QDGCF> 4. select C.KD_REGU, C.NM_REGU
QDGCF> from M_REGU C
QDGCF> inner join M_PELANGGAN B on B.REGU=C.KD_REGU
QDGCF> left join KONSELING A on A.NO_TELP=B.NO_TELP
QDGCF> where A.NO_TELP is null
QDGCF> group by C.KD_REGU, C.NM_REGU
--
Best regards,
Fikri mailto:[EMAIL PROTECTED]
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
