Re: Avoid a subselect "where not equal to"?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 1 Aug 2006 07:45:57 -0700
Message-ID: <1154443557.705285.90350@i3g2000cwc.googlegroups.com>

andrew.fabbro_at_gmail.com wrote:
> (snipped)
>
> And that worked fine. However, someone else referred to this as a
> "nasty" query, opining that "where not in (select...) queries are some
> of the worst" in a performance sense.
>

But ... thats exactly what you want to know, isn't it? -> "Give me all new ones where no open ones exist." So I guess it's OK to ask Oracle exactly that :)

I think this query can scale very well, with the right indexes ...

best,
Martin Received on Tue Aug 01 2006 - 09:45:57 CDT