At 04:05 PM 12/19/2001 +0100, Paul Reeves wrote:

>In any case, you can't index blobs, so your order by could be painfully slow
>if a large result was returned. Perhaps you could store the first eighty chars
>in a varchar field, index it, and order by column instead?

Sorting is faster than an index walk unless the data is stored in
the same order as the sort.



Regards,

Ann
www.ibphoenix.com
We have answers.