RE: Local vs. Global Indexes
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Feb 2004 10:12:25 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ryan
Sent: Wednesday, February 25, 2004 9:34 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Local vs. Global Indexes
I pretty much only use local indexes. Do any of you use global indexes on
partitioned tables and why?
Other related posts:
