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

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members