Using DESC on an index only works with V 4. Philip Smolen wrote:
>I'm trying to make a query faster. It seems simple, but I can't make it >work. > >This is a common case for me: >SELECT * >FROM very_large_table >WHERE (simple_condition) >ORDER BY an_indexed_field DESC >LIMIT 5; >For simple queries this works as expected. MySQL starts at the end of the > --------------------------------------------------------------------- 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