Comment by SkiFire13

> Why don't he use GROUP BY on indexed columns was my first thought also.

Because it has the same issue.

SELECT DISTINCT and GROUP BY are equivalent from a query planner perspective.