Note in-line
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated July 14th
"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message
news:GpCJc.38$K9.208_at_news.oracle.com...
>
> This just emphases how volatile state of the art in SQL optimization is.
> This little trick - stopping after finding first match - was the only
> advantage semijoin tuple iteration semantics had over nested loops. I was
> told lately (but didn't verify) that this optimization has been added to
NL
> as well.
>
If you were thinking of the NL-like method of the FILTER
operation used for subqueries, then it's "roughly" true. There
is an optimization that is designed to minimize the number of
times the filter subquery actually operates.
Received on Fri Jul 16 2004 - 15:22:06 CDT
