Re: LOL: 122 one column indexes on 122 column table
Date: Mon, 22 Feb 2016 16:50:51 -0600
Message-ID: <CAHSa0M2mN1mje1bJa3QPvCp+aY4_14LMA=He7WTHc0vhvvVOzQ_at_mail.gmail.com>
How many rows were in that table Sandra?
On Mon, Feb 22, 2016 at 1:59 PM, Sandra Becker <sbecker6925_at_gmail.com> 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_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-lReceived on Mon Feb 22 2016 - 23:50:51 CET