Not sure why you want that. It will make Rushmore more difficult as every query will need to use the same method to optimize it. I agree with others that ORDER BY in the SELECT clause would be better.

But, if you need it...

INDEX ON DupKey + ("ZZZZZZZZZZZZZ" - Codex) + CopyNo TAG Docky

Note the length of "ZZZZZZZZZZZZZ" is the same as the length of the Codex field.



>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>
>I have tried this but it doesn't work
>
>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky