> Vivek > If you want the data returned in an order, you can create an index with > the order you want, and in your query provide a hint for Oracle to use that > index. If your query is such that Oracle actually uses that index, the data > will be returned in that order. I work with a large application that > entirely depends on this principle. Crude but nevertheless effective.
Ouch!!! Or did you mean that you still use ORDER BY, but index scan helps to avoid sorting? What if this index becomes invalid for some reason, your hint won't be used, and if you don't have order by, your application will fail big time! Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
