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 hibernate @any-related annotations?

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