Re: Index Ordered Table ordering

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 06 Feb 2004 12:19:52 +0100
Message-ID: <bvvsl4$md6$1@news1.tilbu1.nb.home.nl>

Ed Prochak wrote:

> Kris Jenkins wrote:
>

>> Ed prochak wrote:
>>
>>> Kris Jenkins <krisajenkins_at_yahoo.co.uk> wrote in message 
>>> news:<401e2c88$0$16460$cc9e4d1f_at_news.dial.pipex.com>...
>>>
>>>> Hi,
>>>>
>>>> Is there a way to choose the order of Index Ordered Tables?
>>>>
>>>> I've got a table like this:
>>>>
>>>> CREATE TABLE prices (
>>>>     price        integer,
>>>>     id        integer
>>>>     CONSTRAINT prices_pri PRIMARY KEY ( price, id )
>>>> ) ORGANIZATION INDEX;
>>>>
>>>> ...and this gives me a table that is effectively 'ORDER BY price 
>>>> ASC, id ASC'.  What I'd really like is to have it natively stored as 
>>>> 'ORDER BY price *DESC*, id ASC'.
>>>>
>>>> Is that possible?
>>>>
>>>> If not I'll store price as (-1 * price), but that's not ideal.
>>>>
>>>> Cheers,
>>>> Kris
>>>
>>>
>>>
>>>
>>>
>>> you shouldn't care until you query the data. Stop thinking of ORACLE
>>> as a file system and think in terms of tables (ie UNORDERED SETS of
>>> data). Besides your initial assumption is wrong. The indices do not
>>> have any special ordering.
>>
>>
>>
>> I thought that was the whole point of an Index-Ordered-Table (IOT) - 
>> isn't that what the  keywords mean?

>
>
> The O doesn't stand for Ordering. I understood ORGANIZATION INDEX to
> mean that the data is small enough to fit as part of the index. IOW,
> when you query the table, the data is fetched from the index,
> eliminating the need to do a second disc read.
>
> Daniel, can you correct me?
>

Index Organized Table. All data in the index, or: the index is the table. See concepts guide, Part IV, Ch 10

-- 

Regards,
Frank van Bortel

Received on Fri Feb 06 2004 - 05:19:52 CST