News for hackers. Stuff that matters.

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

Re:Can adding an index make a non SARGable query SARGable? by jimktrains2 on Friday October 18, 2019 @07:01PM (#21295740)
I had no idea what sargable was. I guess it means using an index? Is this a sql server specific term? https://www.sqlshack.com/how-to-use-sargable-expressions-in-...

Why not just use a function index?

[ Parent | on HN ]
Re:Can adding an index make a non SARGable query SARGable? by BrentOzar on Friday October 18, 2019 @07:56PM (#21295949)
> I had no idea what sargable was. I guess it means using an index?

Close - it refers to SQL Server being able to take your Search ARGuments (SARG) and do an index seek to jump to the rows you're looking for.

> Is this a sql server specific term?

No: https://dba.stackexchange.com/questions/162263/what-does-the...

> Why not just use a function index?

Microsoft SQL Server doesn't have those.

[ Parent | on HN ]