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

From: Frank Andersen <frank.andersen_at_oslo.online.no>
Date: Sun, 29 Oct 2000 22:12:59 GMT
Message-ID: <Df1L5.2791$Yy1.52636@news1.online.no>

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 - 16:12:59 CST