Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Index Ordered Table ordering
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