Index Ordered Table ordering

From: Kris Jenkins <krisajenkins_at_yahoo.co.uk>
Date: Mon, 02 Feb 2004 10:55:30 +0000
Message-ID: <401e2c88$0$16460$cc9e4d1f@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 Received on Mon Feb 02 2004 - 04:55:30 CST