What makes a query SARGable?
What is SARGability? The word SARGable comes from the term “Search ARGumentable”. This tells if an item can be found by using an index, provided such an index is available. Understanding sargability can really impact the ability to write well-performing queries. If a WHERE clause is not sargable, the Query Optimizer… Continue Reading What makes a query SARGable?
- Posted on:
-
Author:
Satheesh
- Categories: SQL Performance
- Tags: Performance Tuning, SARGable, T-SQL
- Leave a comment: What makes a query SARGable?