An index that retrieves many rows is said to have weak selectivity.
An index that retrieves few rows is said to be strongly selective.
The more strongly selective an index is, the more useful the index is. You may be able to link multiple weakly selective nonunique secondary indexes by bit mapping them. The result is effectively a strongly selective index and a significant reduction in the number of table rows that must be accessed.