At 08:23 PM 10/26/2004, robert_difalco wrote:

> >
> > That would certainly make the problem worse. How many records are
> > you retrieving? How long are the keys? Are you sure that the sort
> > is the problem?
> >
>
>Yes, I'm sure about the problem. The VARCHAR is 1024 in length.

How many records are you retrieving? Do you measure the time it
takes to retrieve all the records or only the time it takes to
retrieve the first? Do you normally retrieve all the records
you select or only the first few?

Regards,


Ann