Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT col_a, (SELECT col_b .....
Hi!
I didn't find anything very instructive from the explain plan either.
Could it be that the optimizer considers the column inline view a query on
its own, and that the
select enters the sql-engine "on its own"- it might get a cursor "of its
own" (v$open_cursor)
I find that the documentation is "reluctant" about this issue :-) unless
someone else has found it.
Frank Received on Fri Jul 06 2001 - 07:28:02 CDT