Ken Menzel wrote: > > Actually it MySQL 4 does. There is a small bug in it right now where > it won't use the descending index witout a range in the where clause, > but this is supposed to be fixed in 4.0.2.
Thanks, I am using MySQL 4. I actually want this for "order by". When I do "create index idx on t (i1, i2 desc, i3)" and then do "show index from t", I only see "A" in the Collation column. When I do "explain select * from t order by i1, i2 desc, i3", I see that it does a filesort. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php