DISTINCT not using an index
123965
Why isn't oracle using an index for distinct query ?
18537
Why using IN(...) when selecting on indexed fields, will kill the performance of SELECT query?
67770
MySQL: Count the distinct rows per day
10328
BigQuery error "Response too large to return" when using COUNT(DISTINCT ...)
96918
How to use index for simple time range join?
120742
MySQL variable format for a "NOT IN" list of values
15186
Postgis spatial index not used
102911
Select rows which are not present in other table
138361
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
64099
oracle sql not a group by expression while counting
93927
Display Top X results for each unique value
158587
Do distinct functions have distinct addresses?
108727
rails - using :select(distinct) with :has_many :through association produces invalid SQL
42491
How do I efficiently get "the most recent corresponding row"?
38452
SQL Not A Single Group Group Function
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
116282
Display each DISTINCT Field Value only once using loop