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
- Chaim.Katz_at_Completions.Bombardier.com 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" <Rich.Jesse_at_qtiworld.com>@fatcity.com
> on 10/01/2002 04:23:22
> PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
> Yes it does, at least on my test instance.
>
> Thanks!
> Rich
>
> Rich Jesse System/Database
> Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech
> International, Sussex, WI
> USA
>
> > -----Original Message-----
> > From: Naveen Nahata
> [mailto:naveen_nahata_at_mindtree.com]
> > 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
> > Rich.Jesse_at_qtiworld.com Quad/Tech
> International,
> > Sussex, WI USA
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> 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: ListGuru_at_fatcity.com (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: Chaim.Katz_at_Completions.Bombardier.com
>
> 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 03 2002 - 04:28:38 CDT
