Re: Performance of (NOT) IN vs. (NOT) EXISTS

Have you thought about using MINUS? I remember going through an excersize similar to yours a couple of years ago, and I remember that the MINUS formulation just flew compared to the NOT IN formulation. Good luck.
Dave

Frank Andersen wrote:

> Hi again,
>
> Thanks for your private e-mail Sybrand, where you ask for more
> information. I've tested the statements with different Oracle versions
> (7.3.4, 8.0.5 and 8.1.6) and they all seem to have the same problem
> with NOT IN.
>
> As to whether or not I am using the cost-based or the rule based
> optimizer, I've got no clue. What is default in Oracle, and how do I
> determine which one I am using? I should also tell you that I'm an OO
> developer not mainly involved in databases unless a query takes two
> days to execute ;-)
>
> I have "the exact explain plan of the affected statements" from Toad
> at work and will post them tomorrow.
>
> Thanks for your advice.
>
> Cheers,
> Frank
Received on Sun Oct 29 2000 - 21:27:23 CST