Hi Michael,

----- Original Message -----
From: "Michael Stassen"
Sent: Wednesday, June 23, 2004 2:30 PM
Subject: Re: INDEX DESC

> Jeremy Zawodny wrote:
> > Why is sorting required at all?  Indexes *are* sorted already.
>
> I expect he's referring to mysql's poor performance when doing "ORDER BY
> indexed_column DESC" relative to "ORDER BY indexed_column ASC".

The performance is only poor when using an index for DESC, *if the index is
PACKED*.  (There's different criteria that determines if a certain index is
packed.)  Otherwise, it should be pretty much exactly the same as ASC.


Matt


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to