SQL Server : Search Arguments (SARG) This is an off-site link.  Please review our Terms of Service for additional information.

Always try to make the queries sargable to optimize the query. If the query is not sargable the query optimizer has to scan all the rows in the table even if that column has an index.

Read this article...

comments powered by Disqus