3 ms·
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.)
by jimktrains2 7y ago
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.)
- BrentOzar 7y ago> 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.
- deleted 7y ago[deleted]
- hotsauceror 7y agoWhat 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.”