Hi Tom,
Can you pls explain the diff between IN and EXISTS and NOT IN
and NOT EXISTS. Because I have read that EXISTS will work better than
IN and NOT EXISTS will work better than NOT IN (read this is Oracle
server tunning).
and we said...
see
http://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:953229842074
It truly depends on the query and the data as to which is BEST.
Note that in general, NOT IN and NOT EXISTS are NOT the same!!!
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:442029737684
On Fri, 16 Mar 2007, Agus Sukayat wrote:
> Untuk data yang besar misal data yang akan diquery sudah jutaan, maka
> query yang menggunakan fungsi exist jauh lebih cepat dibandingkan dengan
> fungsi in.
>
>
>
>
>
>
>
> Salam,
>
>
>
>
>
> Agus Sukayat
>
>
>
> ________________________________
>
> From: [email protected] [mailto:[EMAIL PROTECTED]
> On Behalf Of Amir Nm
> Sent: 16 Maret 2007 8:41
> To: [email protected]
> Subject: [indo-oracle] query where exists vs select in
>
>
>
> kepada semua anggota milist
> saya ingin tahu secara detail fungsi query dengan menggunakan
> where exists atau menggunakan select in
> pada kondisi apa yang lebih baik menggunakan salah satu kondisi di atas
> karena sepintas seperti mempunya fungsi yang sama
>
> terima kasih sebelumnya
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [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
>
>
>
>
