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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What is the intermdiate dataset in this sql?

Re: What is the intermdiate dataset in this sql?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 28 Jun 2005 14:29:10 -0700
Message-ID: <1119994150.767417.193560@g47g2000cwa.googlegroups.com> 





Since no one else chimed it, I'll give you my (possibly dumb) answer.



have you tried running an EXPLAIN PLAN on the queries?



I'm guessing this will depend on the choices made by the Optimiser.


    (How's that for waffling the answer?)



But seriously, if you want to know for sure, ask the ORACLE itself.
Ed
Received on Tue Jun 28 2005 - 16:29:10 CDT












Original text of this message













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