single-row subqueries seer -- join plan?
i've only detected seer lets following:
select foo.a, (select c
bar
where foo.a = bar.a)
from foo
as enlarged wholly quarrel bar matches any quarrel foo.
the explain digest i pl/sql developer this:
select statement, idea = all_rows
list opening full bar
list opening full foo
this doesn't indeed mention tables joined. co-worker asserted some-more fit doing unchanging join. true? join plan such name statement, since doesn't arrangement adult explain plan?
thanks.
Comments
Post a Comment