Hi Stefan,
You have all 122 columns in different combinations searched? Hardly.
It is conceivable, but my experience tells me that most of the time it is pure
incompetence.
I have seen such a situation that you describe with the early "pre-google" web
searcher apps. Much more often people don't know that an index can have more
than one column.
Normally if you want index combine you would go for a bitmap index unless there
could be locking issues.
Regards
Lothar
----Ursprüngliche Nachricht----
Von : contact@xxxxxxxx
Datum : 19/02/2016 - 12:53 (GMT)
An : laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Betreff : Re: LOL: 122 one column indexes on 122 column table
Hi Laimis,
That’s…rude.
Laimutis Nedzinskas <laimutis.nedzinskas@xxxxxxxxxxxxxxxxxxxxx> 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