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: HansF <News.Hans_at_telus.net>
Date: Thu, 08 Dec 2005 23:29:55 GMT
Message-Id: <pan.2005.12.08.23.29.55.524082@telus.net> 





On Thu, 08 Dec 2005 10:43:21 -0800, dean wrote:



> No, I don't need them sorted in the subqueries. I just want to know if

> adding an order by clause is equivalent to adding an index.




Remember that inline views are subqueries, and sorting them can be a
MAJOR advantage.



I do not understand the comment about 'equivalent to adding an index'.
Please expand your concept.


-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***


Received on Thu Dec 08 2005 - 17:29:55 CST












Original text of this message













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