How many rows were in that table Sandra?
On Mon, Feb 22, 2016 at 1:59 PM, Sandra Becker <sbecker6925@xxxxxxxxx>
wrote:
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 <
laimutis.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.