Ok semuanya makasih yahh, sudah lebih faster :)
Wasalam Gugun ----- Original Message ----- From: M Reza Firdausi To: [email protected] Sent: Friday, August 25, 2006 10:04 AM Subject: RE: [indo-oracle] TANYA OPTIMIZE QUERY COBA PK CARA INI MAS GUGUN select * from trdbom a ,( select part_no from titmsp ) b where a.child_part=b. part_no(+) and part_no IS NULL Reza -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Reichkanzler Gugun Sent: 25 Agustus 2006 09:33 To: [email protected] Subject: [indo-oracle] TANYA OPTIMIZE QUERY Para suhu2 SQL help me dunk.. saya ada kasus saya ingin mengquery 2 tabel dengan menggunakan NOT IN dengan cara ini bisa tapi agak lama sekali, karena datanya cukup banyak query yg saya pakai select * from trdbom t where child_part NOT IN ( select part_no from titmsp ) ada cara lain tidak selain yg diatas supaya lebih cepat .. atas bantuannya thx (gugun) __________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __________________________________________________________ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
