Re: Optimization question: Unrolling subquery into IN clause
Date: Fri, 16 Oct 2009 12:33:02 +0000 (UTC)
Jeff <dontspam_at_home.nl> wrote in
> Have you tried rewriting to:
> SELECT several_columns
> FROM tab1
> WHERE col1='Value'
> AND EXISTS
> SELECT key
> FROM tab2
> WHERE tab2.col3='Something'
> AND tab1.col2=tab2.key
Yes, it made no difference. It looks like Oracle always wants to do the "col1='Value'" part first and join that with the result of the subquery resp. EXISTS later.
W. Rösler Received on Fri Oct 16 2009 - 07:33:02 CDT