At 12:15 -0700 9/12/02, PR wrote: >I noticed in the changelog for mysql 4.0.2 that it now > >Use index for ORDER BY in queries of type: SELECT * FROM t WHERE >key_part1=1 ORDER BY key_part1 DESC,key_part2 DESC > >Very cool, I need this. Question though, when creating indexes, do we need >to somehow specify desc in the index or does mysql use the same index for >both asc and desc order by's... >
It uses the same index. --------------------------------------------------------------------- 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
