An index is most efficient when it represents a unique set of values. It's still very useful to have an index for grouping, but if the groups represent a sever

An index is most efficient when it represents a unique set of values. It's still very useful to have an index for grouping, but if the groups represent a severe minority then you will end up wasting a lot of space and cycles searching through the index.