Found something
Re: Optimizing query on table using GENERAL index Thread #
1294254 Message #
1294354So you may want to verify index collation and also code page for the table.
>If I create an index on the last four digits on the SSN field . . .
>
>
>index on right(SSN,4) tag Last4SSN
>
>
>and I have a query that has a where clause like so . . .
>
>
>where right(SSN,4) = "1234"
>
>
>then the way I understand it - and the way the help system seems to indicate - the query is Rushmore optimizable. Yet when I check for the optimization level, it says "none".
>
>What am I missing? Am I misreading the docs or are they lying to me?
>
>Russell Campbell
If it's not broken, fix it until it is.
My Blog