Hi Gerald,
----- Original Message -----
From: "gerald_clark"
Sent: Wednesday, June 23, 2004 2:28 PM
Subject: Re: INDEX DESC
> I suspect he is refering to 3.23's inability to use an index on a ORDER
> BY xxx DESC
That's not always true. 3.23 WILL use the index for ORDER BY ... DESC in a
query like this:
SELECT * FROM table ORDER BY key DESC LIMIT 10
but it won't for this:
SELECT * FROM table WHERE key_part1=123
ORDER BY key_part2 DESC LIMIT 10
e.g. when the index is already used for the WHERE. Of course this was
fixed in 4.0.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
