RE: LOL: 122 one column indexes on 122 column table
- From: Jeff Smith <jeff.d.smith@xxxxxxxxxx>
- To: sbecker6925@xxxxxxxxx, laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx
- Date: Mon, 22 Feb 2016 12:22:30 -0800 (PST)
wouldn't allow us to remove the unused indexes
Thank goodness for
alter index X unusable; --am I right?
From: Sandra Becker [
mailto:sbecker6925@xxxxxxxxx] ;
Sent: Monday, February 22, 2016 2:59 PM
To: laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: LOL: 122 one column indexes on 122 column table
Laimis,
I've seen worse. It was a 3rd-party app. 256 column table had over 2,500
indexes. After monitoring for a month, we discovered that only a dozen of the
indexes were ever used. Vendor wouldn't allow us to remove the unused indexes.
Considering we had heavy inserts/updates on that table, performance was less
than desirable.
Sandy
On Fri, Feb 19, 2016 at 2:58 AM, Laimutis Nedzinskas <HYPERLINK
"
mailto:laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx" ;
\nlaimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx> wrote:
Hi..
I thought I’d seen all.
Not even close:
122 column table.
122 one-column indexes on EACH column.
(BLOBs I don’t count, let them be)
That’s…rude.
/Laimis N
--
Sandy B.
Other related posts: