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.
双语例句
1
This is a sargable predicate, but not an index-sargable predicate (that is, it cannot be applied as a start/stop key on the index scan).