Sargable vs Non-sargable queries
Sargable vs non-sargable query What are sargable and non sargable queries? A query is considered to be sargable if it’s able to take advantage of an index to speed up the execution of a query. A non sargable query is the opposite of that where the dbms engine is unable to take advantage of an index. Person table Let’s say there’s a Person table and an index with the following SQL:...