Sargable

From Wikipedia, the free encyclopedia

You have new messages (last change).

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 (using index seeks, not covering indexes). The term is derived from a contraction of Search ARGument.

[edit] References

SQL Performance Tuning by Peter Gulutzan, Trudy Pelzer (Addison Wesley, 2002) ISBN 0-201-79169-2 (Chapter 2, Simple "Searches")

[edit] See also

Query optimizer

This database software-related article is a stub. You can help Wikipedia by expanding it.

Retrieved from "http://en.wikipedia.org../../../s/a/r/Sargable.html"

Categories: Database management systems | Database software stubs

Views

Search