Hello Alan,

>make a descending index on the same field as well as the ascending one
>BTW do not make a separate index for a field which is the primary key since
>it already has a default asc index created. So if it is the PK, then delete
>the second asc index and create one more desacending index

Actually I created another descending index so there were two: One ASC
automatically created for the key and one DESC which I created.

The speed was the same.

--
Best regards,
Alexander mailto:saho@...