RE: Local vs. Global Indexes

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 26 Feb 2004 10:12:25 -0500
Message-ID: <005701c3fc7a$f101c2e0$8459699f@vttaxnet.tax.state.vt.us>

I have global indexes on my one partitioned table. I tried local indexes and the application ran like a snail so we switched back and everything is ok again. I started with global because that was the default when I partitioned the table, years ago and switched because OEM index tuning wizard suggested it. Bad idea!

HTH,
Ruth
  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ryan   Sent: Wednesday, February 25, 2004 9:34 PM   To: oracle-l_at_freelists.org
  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 - 09:08:47 CST