RE: Need another pair(s) of eyes
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: T.Koppelaars@xxxxxxxxxxxxxxxxxxxx, breitliw@xxxxxxxxxxxxx
- Date: Thu, 26 Jul 2007 12:09:42 +0100 (BST)
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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
