On Tuesday 04 March 2003 09:50, Donna Robinson wrote:
> How can I avoid "Using temporary, "Using filesort"
> when creating indices when my selects MUST be ordered?
Please, check chapter "5 MySQL Optimisation" of the manual. You can find cases
when MySQL uses indexes and when it doesn't use them:
http://www.mysql.com/doc/en/MySQL_Optimisation.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
