RE: Need another pair(s) of eyes

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 26 Jul 2007 12:09:42 +0100 (BST)
Message-ID: <462764.10864.qm@web86913.mail.ukl.yahoo.com>

Hi Wolfgang

They are indeed equivalent .

I think the proof is available in Sql perfromance tuning by Mark Gurry

regards
Hrishy
> Likewise for not exists:
>
> do something (select, update, delete)
> where < some predicates>
> and not exists ( select 'x' from tableA, tableB
> where < some regular predicates > and < some
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
> AIM: WBreitling
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

---

Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now.
http://uk.answers.yahoo.com/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 26 2007 - 06:09:42 CDT