Re: How can I tell a local partitioned index from a global

From: susan mcclain <susie8529_at_hotmail.com>
Date: Tue, 26 Sep 2000 20:59:48 GMT
Message-Id: <10631.117916@fatcity.com>

Hi,

The "locality" column on dba_part_indexes will tell if it's local.

Susan McClain
Manager, DBA
marchFIRST

----Original Message Follows----

From: Cherie_Machler_at_gelco.com
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: How can I tell a local partitioned index from a global Date: Tue, 26 Sep 2000 12:20:59 -0800

I have many partitioned indexes on some very large data warehouse tables. I've been reading about the performance consideration of local versus global partitioned indexes.

Is there an easy way to tell (perhaps from looking at the dba_ind_partitions view)
whether my existing index partitions are for local or global indexes?

Thanks,

Cherie

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:

   INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Tue Sep 26 2000 - 15:59:48 CDT