SARGable is the short form of “Search ARGument able”. A condition in the SQL Query is said to be SARGable if the database engine can take advantage of an available Indexes and do an INDEX SEEK instead of Table Scan / Index scan to speed up the execution of that query.
One of the major mistakes developers do which makes a query non-SARGable is they use functions directly on a column in the WHERE Clause. The next common mistake i have seen is the issues created because of “implicit data type conversions”. In this post I would explain those with few examples.
Click here to read the full post.
Other similar articles :
Hope this will help !!!