>>>You're directing my attention to the fact that Timothy Bowen referred to a LOCATE, probably because the table is not ordered. I have all too easy assumed an indexed order. I've just tested SET ORDER TO 0 DESC. There's no error, but the keyword DESC appears to have no effect. Pity.
>>
>>Probably it should be a rare case where no index is used.
>
>I have added an item to the wishlist:
SET ORDER TO 0 DESC Wish #1409
While I am speculating that it will seldom be used, it does make sense to have it in case you do need it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)