Can adding an index make a non SARGable query SARGable?

Re:Can adding an index make a non SARGable query SARGable? by bfung on Sunday October 20, 2019 @05:54PM (#21307443)

If one thinks about how that index is created underneath the covers, it's basically precomputing that column and using it as an index! =)

[ Parent | on HN ]

Re:Can adding an index make a non SARGable query SARGable? by Tostino on Monday October 21, 2019 @09:48AM (#21312179)

Yes exactly. But it works very well in practice.

[ Parent | on HN ]