>>Bernard,
>>
>>INDEX ON Name FOR Active
>>
>>would probably be the fastest index to use.
>
>Jim, I have never used a filtered index, so I can't test, but isn't it true that filtered indexes aren't optimizable?
Erik,
It is true that filtered indexes are not used by Rushmore, but there is no rule that says the master index can't be filtered while another is not and Rushmore will use the non-filtered index to optimize.