Re: How to know if an index is ASC or DESC ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 6 Aug 2001 12:47:59 +0100
Message-ID: <997098610.16455.0.nnrp-01.9e984b29@news.demon.co.uk>

Although Oracle 7 allows you to use the DESC keyword when building the index, it is there only for compatibility reasons, and is ignored.

All indexes in Oracle 7 are built as ASC.

--
Jonathan Lewis

Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html




toto wrote in message <9klvjt$cos$1_at_news.x-echo.com>...


>Hello,in oracle 8i, we can use table user_ind_columns and its column des

>cend to known if the index is ASC or DESC.But, i cannot find this inform

>ation into my oracle 7 database ?Anyone know how to retrieve this inform

>ation ?

>

>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

>Article poste via Voila News - http://www.news.voila.fr

>Le : Mon Aug  6 13:38:37 2001 depuis l'IP : 195.6.224.137 [VIP 6647606]

Received on Mon Aug 06 2001 - 06:47:59 CDT