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.
随便看	mechanical sector的意思 mechanical sectoring transducer的意思 mechanical sector probe的意思 mechanical sector scan的意思 mechanical sector scanner的意思 mechanical sectors canner的意思 mechanical sector scanning的意思 mechanical sector scan transducer的意思 mechanical sector ultrasonic scanner的意思 mechanical sediment的意思 mechanical sedimentation的意思 mechanical sediments的意思 mechanical segregation的意思 mechanical seismograph的意思 mechanical selection的意思 mechanical selector的意思 mechanical self starter的意思 mechanical sense的意思 mechanical sensor的意思 mechanical sensory system的意思 mechanical separate的意思 mechanical separation的意思 mechanical separator的意思 mechanical series circuit的意思 mechanical servicing的意思