Re: Help on DESC index
Date: Mon, 18 Dec 2000 23:13:06 -0700
Message-ID: <3A3EFC72.25DABF25_at_usa.net>
With release 8.1.5 the DESC option when creating an index actually does create the index with the values arranged in descending order.
Be careful though! We had been relying on the INDEX_DESC hint to get a quirky performance boost out of our application. When we switched to taking advantage of the CREATE INDEX ... DESC feature of 8.1.5, our performance suffered a 100% decrease. Our shop (myself in particular) is quite good about tuning SQL and PLSQL, so it wasn't our code. Something in the way that Oracle 8i creates or stores or retrieves values from a DESC index isn't implemented very well.
Andrew Au wrote:
> Can someone explain to me what does Create index ...desc do? Is it used for
> Select * from table order by x desc.. or something like that??
> Please Email me directly as well as posting to this group. Thanks.
Received on Tue Dec 19 2000 - 07:13:06 CET