Sargable

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.

A query failing to be sargable is known as non-sargable query and has an effect on query time, so one of the steps in query optimization is to convert them to be sargable. The effect is similar to searching for a specific term in a book that has no index, beginning at page one each time, instead of jumping to a list of specific pages identified in an index.

单词	Sargable
释义	Sargable 英语百科 Sargable 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. A query failing to be sargable is known as non-sargable query and has an effect on query time, so one of the steps in query optimization is to convert them to be sargable. The effect is similar to searching for a specific term in a book that has no index, beginning at page one each time, instead of jumping to a list of specific pages identified in an index.
随便看	unibus adapter的意思 unibus computer的意思 unibus selector的意思 unibus structure的意思 unibus system的意思 Unic的意思 UNICA的意思 unical的意思 unicalcaratus的意思 Unicam的意思 unicameral的意思 Unicameral Bone Cyst的意思 unicameral cyst的意思 Unicameralism的意思 Unicameral legislature的意思 Unicamerally的意思 unicameral的意思 unicameral script的意思 Unicameral System的意思 unicamerate的意思 unicam high temperature x ray camera的意思 unicams的意思 Unicap的意思 Unicap Capsules的意思 unicapsular的意思