When doing a select that is ordered by a column that is indexed and has a
limit, does mysql not use the index if the order by is descending?
Here's an example:
select parent,number,lastpost from posts where topic=1 and board='abc' and
approved='yes' order by lastpost desc limit 9,12
My app is a
On Mon, Sep 10, 2001 at 09:13:06AM -0700, PR wrote:
And are there future plans for indexing on desc order?
This is already fixed in MySQL 4.0.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL