Use an HNG index when:
The number of unique values is high (greater than 1000)
You don't need to do GROUP BY on the column