List:General Discussion« Previous MessageNext Message »
From:Oscar Date:December 22 2009 5:02am
Subject:ORDER BY favours full scan over a faster filesort
View as plain text  
hi all,

it said the bug  has been fixed in 5.1.25.
See http://bugs.mysql.com/bug.php?id=35844



# Query_time: 1.657438  Lock_time: 0.000085 Rows_sent: 40  Rows_examined: 885756
SET timestamp=1261447735;
select item0_.id as id163_, item0_.add_time as add2_163_ from item
item0_ where item0_.role_id=2556 order by item0_.id desc;


mysql version: 5.1.34



have you guys met this problem?

thanks,

-Oscar
Thread
ORDER BY favours full scan over a faster filesortOscar22 Dec