Hello. I'm new to this mailing list :+) I created a mutilple-column index, say
"create index col1_col2 on table_name (col1,col2) " Both col1 and col2 are mediumint unsigned. "explain select * from table_name where col1='value' order by col1 DESC,col2 DESC " shows that the query is still using filesort ! This is not supposed the be the case. Mysql manual says it should read the index backward. what is happening here? anyone know? It's MySql version 3.23.23. Not including "DESC" doesn't use any filesort. many thanks Peaw __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.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
