>If one has a primary index on a key field that sets a flag on !DELETED(), does one need a second index on the same expression w/o the filter for full Rushmore optimization?
>
If you're using a FOR clause, definitely yes; I'm not certain about the situation where you have a character field and you do something to concatenate the result of an IIF(DELETED(),
some char expn>,some other char expn) as a part of the key.
>TIA