[WEBINAR] Application Acceleration: Faster Performance for End Users


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.
In most cases, the databases management system's query optimizer will identify opportunities to improve queries by making them sargeable.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.