Re: LOL: 122 one column indexes on 122 column table

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_at_statoilfuelretail.com> 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.

--
http://www.freelists.org/webpage/oracle-l