• We have a very similar situation, and are looking forward to upgrading and making use of filtered indexes.

    It's not clear to me... did you try using filtered indexes with just the "status" field, and still had problems with complex queries? Or were the problems you experienced in prior versions, where the "status" index was a regular (non-filtered) index.

    Thanks.