Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.cc.ukans.edu!newsxfer.eecs.umich.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer01.lnd.ops.eu.uu.net!lnewsinpeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
Date: Mon, 02 Feb 2004 10:55:30 +0000
From: Kris Jenkins <krisajenkins@yahoo.co.uk>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Index Ordered Table ordering
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 22
Message-ID: <401e2c88$0$16460$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Date: 02 Feb 2004 10:55:04 GMT
NNTP-Posting-Host: 81-178-1-69.dsl.pipex.com
X-Trace: 1075719304 news.dial.pipex.com 16460 81.178.1.69:50268
X-Complaints-To: abuse@uk.uu.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:135249

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