This is correct, the index is not packed. Also, exactly the same
behavior can be observed if "GROUP BY" is used instead of "DISTINCT" -
if this makes my case any clearer. The table gets checked for
consistensy and optimized every hour.
I wonder if any members of MySQL development crew could she
Hi,
MySQL 4+ can use indexes for ORDER BY ... DESC (3.23 can only in some
cases) in every case that ASC can. However, reading a packed index in
reverse order is slower. I don't think your index is packed, though, if
it's a date-type column, unless you've specified PACK_KEYS in your
CREATE TABLE.
ssage -
From: Donny Simonton
To: 'Vadim P.' ; [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 9:34 PM
Subject: RE: "ORDER DESC" vs. "ORDER ASC" exec time
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my
Personally, it's an unexpected flaw that I hope one day will be fixed. But
I'm not holding my breath, even though they seem to be planning for it. But
it could also be because of query-cache.
To benchmark something like this, you really need to add SQL_NO_CACHE to
your select statement to get ac
