News for hackers. Stuff that matters.

A comment on Can adding an index make a non SARGable query SARGable?. Parent comment

Re:Can adding an index make a non SARGable query SARGable? by jimktrains2 on Friday October 18, 2019 @07:41PM (#21295900)
Can you explain what sargable is? I've never used SQL server, but I'm sure a similar expression could be indexed in postgresql. (Not at a computer to check.)
[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by BrentOzar on Friday October 18, 2019 @07:55PM (#21295945)
> Can you explain what sargable is?

It means that the database take your Search ARGuments (SARG) and do an index seek to deliver the exact results you want.

[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by hotsauceror on Friday October 18, 2019 @08:18PM (#21296028)
What Brent said. I basically interpret it to mean “this expression can not be satisfied (covered) by the use of an index even if an appropriate one existed.”
[ Parent | on HN ]