| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: will the Return Order of rows change with time ?
Thanks a lot to all those people who replied to my query.
answering stephane question : the table is 500MB+ , and there
is no unique key since it is a child table.
Moreover presently i cannot modify the table.
The general concensus is that there is no guarantee of return
order of rows without using order by clause.
Anybody knows why this is so ?
Oracle must be having a fixed algorith for data access , probably
using the extent map.
Assuming
1. no query parallelism & no deletes/updates to table
2. no index/optimizer/structure changes
the data retrieval path should not change with time for the same query ??
thanks & regards
ratnesh singh
-----Original Message-----
Kumar Singh
Sent: Tuesday, October 22, 2002 4:09 PM
To: Multiple recipients of list ORACLE-L
Hi
I have a very large DW table in which there are only inserts and NO updates/deletes.The table grows by around 2-5 % every week due to new inserts.
I need to return the rows for each customer in the same order as inserted to table.Due to design/delivery constraints , i cannot modify the table.
ques 1 : if i do a 'select * from table' with where clause but no order by clause,will the Order of rows returned be the same whenever this query is executed ? Is this guaranteed by Oracle ?
ques 2 : if i export/import this table , then execute the same query, will the Order of rows returned be the same as before the export/import ?
ques 3 : if i use the 'move' cmd to rebuild this table , then execute my query,will the Order of rows returned be the same as before the rebuild ?
any explanations are most welcome....
many thanks
ratnesh singh
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: ratnesh.singh_at_patni.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Oct 23 2002 - 01:58:46 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: ratnesh.singh_at_patni.com 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: ListGuru_at_fatcity.com (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).
 |
 |