Re: Local vs. Global Indexes

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 26 Feb 2004 08:31:28 -0500
Message-ID: <BAY9-DAV17DPjea2LWk000045e1@hotmail.com>

We have an app where it's necesary to partition on a date field for maintenance and data loading.. However all queries use a userid. Local index had way to many index probes and performance went down the tubes. Put a global index on userid and everyones happy. The 30 minute downtime to rebuild the index during partition maintenance is acceptable to the users.

Mike
ganstadba_at_hotmail.com
----- Original Message -----

From: Ryan
To: oracle-l_at_freelists.org
Sent: Wednesday, February 25, 2004 9:33 PM Subject: Local vs. Global Indexes

I pretty much only use local indexes. Do any of you use global indexes on partitioned tables and why?

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Feb 26 2004 - 07:31:09 CST