Filtered indexes are just an index with a where clause. Oh, but it’s much more complex than that. See, your query’s clause doesn’t have to match exactly, but it has to be a subset of the index’s filter, and it can’t be parameterized. Jeremiah explains the limitations, defines the right use cases, and shows demos...
We don't sell this anymore, but check out our other training options.