SARGABILITY, CAST, CONVERT & More…
The phrase Sargability is quite popular in SQL Server world.
Wikipedia says: “In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of an index to speed up the execution of the query. The term is derived from a contraction of Search ARGument ABLE.”
Does this mean “the ability of the SQL Server engine to use the search argument to perform an index seek operation?”.
Yes, kind of. Let’s understand with some examples.
Continue Reading: https://sqlmaestros.com/sargability-cast-convert-more/