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

Popular posts from this blog

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?

grails record upload problems

how i emanate permitted url asp.net mvc?