Re:Can adding an index make a non SARGable query SARGable?
by heavenlyblue on Sunday October 20, 2019 @06:05AM
(#21303233)
Let's be honest - this is an SQL-server only issue. Nobody says you can't index NULL values, it's just that SQL server can't do that.
[ Parent
| on HN ]
Re:Can adding an index make a non SARGable query SARGable?
by hotsauceror on Sunday October 20, 2019 @12:02PM
(#21304954)
That’s not quite true. You can certainly index null values, and you can filtered indexes to remove nulls. What sql server cannot do is index functions themselves, and use those indexes to satisfy queries with nonsargable expressions.