>Hi Naomi,
>
>>You may try to add a filter on NOT DELETED() for the index.
>
>However, then the index won't be used for Rushmore optimization.
>
>>Chose BINARY for the type of such index.
>
>BINARY and the FOR clause are mutually exclusive.

Thanks, Christof. I remember reading article in CoDe Magazine, but I forgot the actual details.

I believe the filtered indexes can be used for Rushmore, if memory serves? Or what is the exact deal with FOR and BINARY index?