What’s faster, SELECT DISTINCT or GROUP BY in MySQL?

by

They are essentially equivalent to each other (in fact this is how some databases implement DISTINCT under the hood).

If one of them is faster, it’s going to be DISTINCT. This is because, although the two are the same, a query optimizer would have to catch the fact that your GROUP BY is not taking advantage of any group members, just their keys. DISTINCT makes this explicit, so you can get away with a slightly dumber optimizer.

When in doubt, test!

More Related Contents:

  1. Count the occurrences of DISTINCT values
  2. Selecting distinct 2 columns combination in mysql
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. How to select the nth row in a SQL database table?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How to do a batch insert in MySQL
  8. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  9. Storing JSON in database vs. having a new column for each key
  10. How do I restore a dump file from mysqldump?
  11. Group mysql query by 15 min intervals
  12. Cast int to varchar
  13. Is it possible to GROUP BY multiple columns using MySQL?
  14. Check for x consecutive days – given timestamps in database
  15. Using Count to find the number of occurrences
  16. How do I get the ID of multiple inserted rows in MySQL?
  17. Import SQL file into mysql
  18. Does mysql have the equivalent of Oracle’s “analytic functions”?
  19. How to skip certain database tables with mysqldump?
  20. “where 1=1” statement [duplicate]
  21. How to set a MySQL row to READ-ONLY?
  22. MySQL: LAST_INSERT_ID() returns 0
  23. Remove special characters from a database field
  24. Using reserved words in column names
  25. Calculating a Moving Average MySQL?
  26. MySQL – Replace Character in Columns
  27. Strings as Primary Keys in MYSQL Database [closed]
  28. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  29. What is the difference between SQL and MySQL? [closed]
  30. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;

Leave a Comment