how many is too many columns in a composite index
843332May 9 2011 — edited May 10 2011hi all, (using 10g r2)
i do realize that there is not an exact right answer, but im more curious to find out how others have handled this situation, for better or for worse...
i know the literal upper bound on the number of columns that can be part of a composite index but i was wondering if any of you had come up with what you feel to be practical or upper bounds on the number of columns in a composite index? Also, can anyone share info on what might be strategy to figure out at what point the number of columns in the index creates a situation where updating/maintaining the index outweighs any performance gain you get from the composite index? Thanks in advance! -- jp