>Hi,
>
>When I try the following SQL Select
>
>
>select top 100 * from mytable order by pkfield desc
>
>
>the SYS(3054) reports Rushmore optimization as None.
>
>How can I change the expression to be Rushmore optimized?
>
>TIA.
An index on pkfield ought to do it.
What data type is pkfield?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________