Does the order of columns in a WHERE clause matter?

by

With a decent query optimiser: it shouldn’t.

But in practice, I suspect it might.

You can only tell for your cases by measuring. And the measurements will likely change as the distribution of data changes in the database.

More Related Contents:

  1. What makes a SQL statement sargable?
  2. What do Clustered and Non-Clustered index actually mean?
  3. Which are more performant, CTE or temporary tables?
  4. SQL Server: Query fast, but slow from procedure
  5. XML Server XML performance optimization
  6. Using varchar(MAX) vs TEXT on SQL Server
  7. SQL Server pivot vs. multiple join
  8. LIKE vs CONTAINS on SQL Server
  9. SQL Server Query: Fast with Literal but Slow with Variable
  10. cross apply xml query performs exponentially worse as xml document grows
  11. Which is quicker COALESCE OR ISNULL?
  12. Slow query with cfqueryparam searching on indexed column containing hashes
  13. SQL Server – error when creating stored procedure
  14. How do I enable MSDTC on SQL Server?
  15. Change type of a column with numbers from varchar to int
  16. Get row where datetime column = today
  17. ‘Incorrect SET Options’ Error When Building Database Project
  18. Create Stored Procedures using Entity Framework Code First?
  19. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  20. SQL Server – How to insert a record and make sure it is unique
  21. Full text catalog/index search for %book%
  22. “If not exists” fails on SQL CE
  23. Does the `nodes()` method keep the document order?
  24. Why insert-select to variable table from XML variable so slow?
  25. Set database name dynamically in SQL Server stored procedure?
  26. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  27. Docker SQL bind: An attempt was made to access a socket in a way forbidden by its access permissions
  28. Generate MD5 hash string with T-SQL
  29. Why can’t Entity Framework see my Stored Procedure’s column information?
  30. How to avoid SSIS FTP task from failing when there are no files to download?

Leave a Comment