Oh I see. Since I really need this DESC badly, is it sensible to add a 3rd column that keeps its values in reverse order(say, SomeBigInt - value of col2) ? Then create an index on (col1,col3) and use it without the "DESC".
The website does about 10 times more reading than updating the table. There are 12 columns and about 100000 rows in the table. regards, Peaw. --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Wed, Jan 30, 2002 at 06:21:20PM +0000, peaw peaw wrote: > Hello. > I'm new to this mailing list :+) > > I created a mutilple-column index, say > > "create index col1_col2 on table_name (col1,col2)" > > Both col1 and col2 are mediumint unsigned. > > "explain select * from table_name where > col1='value' > order by col1 DESC,col2 DESC " > > shows that the query is still using filesort ! > This is not supposed > the be the case. Mysql manual says it should read > the index > backward. That was added in MySQL 4.0. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 27 days, processed 615,862,667 queries (255/sec. avg) __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com --------------------------------------------------------------------- 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
