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

> That’s…rude.

… or needed by design. Just think about dynamic queries with all possible predicate combinations - impossible to create proper (composite) indexes for all these cases. It may be a valid approach to index each column and let the optimizer work out the combinations (+ "B-tree to Bitmap Conversions"). They also can be used in joins.

Not everything is as crazy as it looks at first view ;-)

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> Laimutis Nedzinskas <laimutis.nedzinskas_at_statoilfuelretail.com> hat am 19. Februar 2016 um 10:58 geschrieben:
>
> 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

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