>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?
If it's not broken, fix it until it is.
My Blog