> If you create a new table and insert records, you can be pretty sure that > when you query them, they will come out in the same order.
No, you can't. For example when parallel query is used, each slave reads it's own set and the returning order isn't guaranteed. The same with indexes, what if fast full scan is used... you cant be sure. Tanel. > > *BUT* - once you delete a record and insert more new records, the order > becomes random. this is because Oracle will reuse the space vacated by the > deleted records. I don't know of any way to predict how it will use that > space. That's why you should always include an "order by" clause. > > Hope this helps. > > > Tom Mercadante > Oracle Certified Professional -- 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).
