Depends on the version I think. Oracle has always allowed DESC indexes, but only in 9(?) is the keyword actually used in the index build.
hth connor --- [EMAIL PROTECTED] wrote: > > but there is a "create index ... desc"? > > ASC | DESC > specifies whether the index should be created in > ascending or descending > order. > Oracle treats descending indexes as if they were > function-based indexes. > You do not need the QUERY REWRITE or GLOBAL QUERY > REWRITE privileges to > create them, as you do with other function-based > indexes. > > Chaim > > > > > "Jesse, Rich" <[EMAIL PROTECTED]>@fatcity.com > on 10/01/2002 04:23:22 > PM > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > > > > Yes it does, at least on my test instance. > > Thanks! > Rich > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI > USA > > > -----Original Message----- > > From: Naveen Nahata > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 01, 2002 12:28 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Indexing SYS tables > > > > > > Again since the indexes store the row in ordered > fashion, I > > guess a normal > > index should be able to do ORDER BY DESC by > reading backwards > > > > Not sure though > > > > Regards > > Naveen > > > > -----Original Message----- > > Sent: Tuesday, October 01, 2002 10:33 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Yes, you are obviously correct. I really need to > RTFM. > > <sigh> Too many > > pots on the stove! > > > > Just a regular index, then. Any other input? > > > > Thx! > > Rich > > > > Rich Jesse > System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech > International, > > Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
