On Sun, 8 Jun 2003 12:24:44 +0000 (UTC), Helen Borrie wrote:

>> ...
>
> No. You must have an index on an ORDER BY field.

Helen, quite often an index on a ORDER BY field is not a good thing -
sorting is usually fast. Unless I only need the first record, I use
indexes for the WHERE clause, not for the ORDER BY. YMMV.


--
Aage J.