Sargable

A condition in a query is sargable if the query engine can make use of an index to speed up the query.