Which SQL statement is faster? (HAVING vs. WHERE…)

by

The theory (by theory I mean SQL Standard) says that WHERE restricts the result set before returning rows and HAVING restricts the result set after bringing all the rows. So WHERE is faster. On SQL Standard compliant DBMSs in this regard, only use HAVING where you cannot put the condition on a WHERE (like computed columns in some RDBMSs.)

You can just see the execution plan for both and check for yourself, nothing will beat that (measurement for your specific query in your specific environment with your data.)

More Related Contents:

  1. How do I obtain a Query Execution Plan in SQL Server?
  2. select * vs select column
  3. Inner join vs Where
  4. INNER JOIN vs LEFT JOIN performance in SQL Server
  5. Equals(=) vs. LIKE
  6. SQL JOIN vs IN performance?
  7. Is a view faster than a simple query?
  8. Multiple INSERT statements vs. single INSERT with multiple VALUES
  9. Why would an IN condition be slower than “=” in sql?
  10. Does the order of where clauses matter in SQL?
  11. SQL Joins Vs SQL Subqueries (Performance)?
  12. Normalize array subscripts so they start with 1
  13. Does Foreign Key improve query performance?
  14. Performance of inner join compared to cross join
  15. Counting DISTINCT over multiple columns
  16. Spark sql queries vs dataframe functions
  17. How to count occurrences of a column value efficiently in SQL?
  18. Favourite performance tuning tricks [closed]
  19. SQL primary key: integer vs varchar
  20. Can an INNER JOIN offer better performance than EXISTS
  21. How to check which locks are held on a table
  22. Huge performance difference when using GROUP BY vs DISTINCT
  23. SQL Server 2008 paging methods?
  24. Get execution time of PostgreSQL query
  25. Performance of Cross join with WHERE clause compared to Inner join
  26. IN vs. JOIN with large rowsets
  27. What is the fastest way to truncate timestamps to 5 minutes in Postgres?
  28. IF() statement alternative in SQLite
  29. IN vs OR of Oracle, which faster?
  30. sql query joins multiple tables – too slow (8 tables)

Leave a Comment