Re: Descending indexes in 10g

From: Andy Kent <andykent.bristol1095_at_virgin.net>
Date: 25 May 2006 09:35:39 -0700
Message-ID: <1148574939.018986.275100@i39g2000cwa.googlegroups.com>

I'm confused - the Concepts manual doesn't appear to make any reference to ASC / DESC, but the SQL Reference states:

Oracle Database treats descending indexes as if they were function-based indexes. As with other function-based indexes, the database does not use descending indexes until you first analyze the index and the table on which the index is defined.

... which seems to me to imply that descending indexes are still a valid construct ... ?

Andy Received on Thu May 25 2006 - 11:35:39 CDT