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.
随便看	mouldproof packaging mouldproof paper mouldproof test mould protease mould rain mould rains mould, reciprocating mould release mould release agent mouldrelease agent mould releasing agent mould relese mould resistance mouldrie mould rollover unit mould, rotary mould, rotating mould round mouldry mould sand mould sb. like wax mould sb like wax mould seam mould setting and stripping building moulds from rubber