>What is the FOR clause of a primary key?
>
>Vlad
>
>>Rushmore will not use your primary keys because they contain FOR clauses. If you want Rushmore optimization, you must use indexes without FOR clauses whose index expressions EXACTLY match the expression being compared.
I misread his original message; it is possible to construct a primary key with a FOR clause (there was a thread on this last week) and including a FOR clause in an index, primary or otherwise, results in it not being used for Rushmore optimization.