List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 12 2002 7:20pm
Subject:Re: mysql4 - order by, desc queries and indexes
View as plain text  
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.

Thread
mysql4 - order by, desc queries and indexesPR12 Sep
  • Re: mysql4 - order by, desc queries and indexesPaul DuBois12 Sep