Hi Lothar,
the 122 columns are extreme of course, but i just wanted to say that a lot of
single column indexes can make sense too. It is not always all for
nothing.
Normally if you want index combine you would go for a bitmap index unless
there could be locking issues.
"l.flatz@xxxxxxxxxx" <l.flatz@xxxxxxxxxx> hat am 19. Februar 2016 um 14:32--
geschrieben:
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