The Pains of Filtered Indexes

In a previous post I briefly went over how useful filtered indexes can be.  Filtered indexes are a great feature that have numerous uses.  However, like almost everything in computing, there are trade-offs, and filtered indexes are no exception.  The challenge with filtered indexes is the decisions that the query optimizer can make regarding them. …

9