Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT col_a, (SELECT col_b .....

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

From: Frank <franjoe_at_frisurf.no>
Date: Fri, 6 Jul 2001 14:28:02 +0200
Message-ID: <Zai17.3524$Jp5.54805@news1.oke.nextra.no> 






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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US