Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
Sargeable
Definition - What does Sargeable mean?
A sargeable query, in the context of a relational database, is one where indexes can improve the speed and efficiency of a query. As a result, it is highly desireable to have sargeable SQL queries.
Sargeable is derived from a contraction of Search ARGument ABLE.
Techopedia explains Sargeable
There are several circumstances where non-sargeable queries creep in:
- Whether predicates in WHERE clauses and JOIN clauses will prevent the use of an index
- Where a function is included in the left part of a condition of a WHERE clause
- When the time required to perform a SEEK on a table is greater than scanning an index when joining one table or result set onto another. Usually a seek is much faster than scanning a whole table, but when you have to seek a lot of rows, a scan could be more efficient.
.jpg?width=360&height=240&mode=crop)
![[Free eBook] Introduction to Artificial Intelligence (a $14.95 Value)](http://www.techopedia.com/images/uploads/w_unir01c8w.jpg?mode=fit&width=200&height=150)
![[Free Research Report] Data Center & Infrastructure Report: Outlook for 2020](http://www.techopedia.com/images/uploads/data-center-report-aad.jpg?mode=fit&width=200&height=150)
