Sounds like what you are looking for is a CLUSTER or an INDEX
ONLY table.
In a regular table Oracle stores the records any way it wishes.
You retrieve in a desired order using the order by.
In a CLUSTER the data is stored based on the key and an INDEX
ONLY table is similar.
Becca
>
>
> Is there a concept of clustered index in Oracle (like
Sybase)?
>
> What determines the order of which records are stored in
Oracle?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8048&cus_id=USENET&qtn_id=9385
Received on Thu Nov 18 1999 - 15:52:57 CST
