Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Oracle create temporary indexes for sub queries?
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