Assertion: predicate | /r/HasProperty | sargable
Facets:
value: for sql server
type: OTHER
value: to be able
type: PURPOSE
Source sentences:
text: So a predicate must be SARGable to be able to use an index seek, and it must be able to use an index seek to be SARGable.
text: So what does it actually mean for a predicate to be SARGable?
text: To be SARGable, a predicate must, on one side, have a column, not an expression on a column.
text: The other requirement for a predicate to be SARGable, for SQL Server at least, is that the column and expression are of the same data type or, if the data types differ, such that the expression will be implicitly converted to the data type of the column.
text: Predicates with LIKE are only SARGable if the wildcard is not at the start of the string.
text: (1) An explicit CAST of a DATE column to DATETIME still leaves the predicate SARGable.