mysql, ifnull vs coalesce, which is faster?

by

My view is that you should benchmark for your usage.

I doubt there will be much difference.
Bear in mind that while a single benchmark might suggest that one is slightly better, variation in the data over time might change that result.

Also note that COALESCE has been part of standard SQL since 1992 – I’m not sure IFNULL is in any standard yet.

There’s a nice article by Adam Machanic about benchmarking an equivalent scenario – Performance: ISNULL vs. COALESCE (in SQL Server). Note some of the provisos on getting a valid test.

More Related Contents:

  1. How to do the Recursive SELECT query in MySQL?
  2. JOIN queries vs multiple queries
  3. MySQL indexes – what are the best practices?
  4. Subqueries with EXISTS vs IN – MySQL
  5. mysql select from n last rows
  6. Difference in MySQL JOIN vs LEFT JOIN
  7. 60 million entries, select entries from a certain month. How to optimize database?
  8. Checking multiple columns for one value
  9. Mysql Improve Search Performance with wildcards (%%)
  10. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  11. Higher cardinality column first in an index when involving a range?
  12. MySQL “IN” queries terribly slow with subquery but fast with explicit values
  13. MySQL: Can I do a left join and pull only one row from the join table?
  14. How to optimise MySQL queries based on EXPLAIN plan
  15. How to estimate SQL query timing?
  16. Deleting millions of rows in MySQL
  17. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  18. Count the occurrences of DISTINCT values
  19. Column count doesn’t match value count at row 1
  20. MySQL > Table doesn’t exist. But it does (or it should)
  21. How do I modify a MySQL column to allow NULL?
  22. Connect to mysql in a docker container from the host
  23. Set NOW() as Default Value for datetime datatype?
  24. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  25. How can I implement single table inheritance using Laravel’s Eloquent?
  26. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  27. MySQL Time Zones
  28. Mysql select where not in table
  29. Which DATATYPE is better to use TEXT or VARCHAR?
  30. How can I stop a MySQL query if it takes too long?

Leave a Comment