Re: Does Oracle create temporary indexes for sub queries?

From: HansF <News.Hans_at_telus.net>
Date: Thu, 08 Dec 2005 16:12:26 GMT
Message-Id: <pan.2005.12.08.16.12.26.222094@telus.net>

On Wed, 07 Dec 2005 21:33:59 -0800, dean wrote:

> Do you know if its necessary to use an ORDER BY clause?

Absolutely, unequivocally, 100% of the time - maybe!!!!

It kinda depends on what you are trying to do. Do you want the results ordered (sorted)?

-- 
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 - 10:12:26 CST

This message: [ Message body ]
Next message: gareth_at_jamms.org: "Re: ora -01843"
Previous message: dean: "Re: Can you pass a table name into a stored procedure?"
In reply to: dean: "Re: Does Oracle create temporary indexes for sub queries?"
Next in thread: dean: "Re: Does Oracle create temporary indexes for sub queries?"
Reply: dean: "Re: Does Oracle create temporary indexes for sub queries?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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