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: Does Oracle create temporary indexes for sub queries?

Re: Does Oracle create temporary indexes for sub queries?

From: dean <deanbrown3d_at_yahoo.com>
Date: 13 Dec 2005 01:27:52 -0800
Message-ID: <1134466072.391459.316160@g44g2000cwa.googlegroups.com> 





Thanks jg, that makes good sense. I wasn't asking for a global answer
to all SQL statements, just seeing if there was a general consensus on
getting the best performance, i.e. if this were a typical thing that
people either add to their subqueries or not.



-Dean
Received on Tue Dec 13 2005 - 03:27:52 CST












Original text of this message













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