Re: SELECT col_a, (SELECT col_b .....

I always assumed that it was being implemented by the same mechanism as user defined functions. Which makes me wonder if it is read consistent with the start of the main statement, because user-defined functions are not.

On Fri, 6 Jul 2001 14:28:02 +0200, "Frank" <franjoe_at_frisurf.no> wrote:

>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 Sat Jul 07 2001 - 03:03:07 CDT