Sargable - AbsoluteAstronomy.com

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

Index (database)

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space...

to speed up the execution of the query (using index seeks, not covering indexes). The term is derived from a contraction of Search ARGument ABLE.

The source of this article is wikipedia, the free encyclopedia. The text of this article is licensed under the GFDL.