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]