Re: exists processing

Jeff Kish <jeff.kish_at_mro.com> wrote in message news:<9fcam0lf14qg9jdbb7ahjj3qdm7ni0p8p2_at_4ax.com>...
> Could someone explain how this is processed by the database?
>
> I'm having trouble formulating these correctly because I don't quite
> understand how the database processes exists.
>
>
> select count(*) from table1
> where (locationid like '%SOMEVALUE1%') and (exists (select job from table2
> where (( contains(description,' $Carpenter ') > 0 )) and (job
> in (select job from jobtable where job is not null and
> locationid=table1.locationid))))
>
>
> Actually if there is a good explanation on how to methodically take these
> suckers apart and figure
> out how the database processes them that'd be fine also.

http://asktom.oracle.com/pls/ask/f?p=4950:8:18436658121816782799::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:953229842074,

is pretty informative.

jg

--
@home.com is bogus.
http://www.votorgasm.com/