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
:
patni.comSubject: RE: will the Return Order of
rows change with time ?
Sent by:
[EMAIL PROTECTED
:
patni.comSubject: RE: will the Return
Order of rows change with time ?
Sent by:
[EMAIL PROTECTED]
m
23/10/2002
16:58
Please respond
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
Hi
Without a order claus on the statement there is no granti of the order
the rowes are rurned.
This is not specific to Oracle but part of the sql standard.
Ratnesh Kumar Singh wrote:
Hi
I have a very large DW table in which there are only inserts and NO
updates/deletes.
The table grows by
When doing many select you should have the same order
but this is not guaranteed by Oracle.
The only official guaranty is to use an order by.
After an export/import or a move, you have the risk
that the rows will not be in the same order.
How big is the table ?
There is no unique id for the
Ratnesh,
Oracle will return the rows in order of physical access, which is
determined by the access path. This can be a full table scan, index read or
the result set from another operation. If parallelism is used, the return
order can be altered. Updates/Deletes, export/import, rebuilds