Oracle-L: RE: Indexing SYS tables

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Wed, 02 Oct 2002 13:18:21 -0800
Message-ID: <F001.004DE9CF.20021002131821@fatcity.com>

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).

Received on Wed Oct 02 2002 - 16:18:21 CDT