Re: mysql4 - order by, desc queries and indexes

[Paul DuBois]

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.