I didn&#x27;t say an index couldn&#x27;t be used at all. Just not to actually make the query fast. This will get all duplicates for a value from the index, before going to the next value. If you have a couple thousand or more of each to be counted value that&#x27;ll make the query rather slow.