Aage,

At 02:33 PM 8/06/2003 +0200, you wrote:

>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.

With 27,000 records ordered on a varchar column, it aint going anywhere
fast with no index. YMMV.

heLen