>Hi Michael,
>
>Unless you use more advanced SQL commands, try SET ENGINEBEHAVIOUR 70 before running your query. I have found in some cases that it makes a huge difference to query speed.
>
>Regards,
>Alan

Yes, but be VERY careful, since you may also get wrong results! Set enginebehavior 70 (or 80) should only be used as a short time emergency solution. You should FIX the selects instead!