SQL Server’s Filtered Indexes Don’t Always Have To Be Selective

Somewhere Between

I’ve had quite a bit of luck with filtered indexes over the years. When they work well, they’re absolute aces.

But there’s a bit of trickiness to them, both for getting the optimizer to match the expression in …