Just saw this run by on the MySQL mailing list. Might help us? (Also, I've enabled the 'slow query log' on the mysql server; I'll have a look at the results come tomorrow...) -- brion vibber (brion @ pobox.com) -----Forwarded Message----- From: Heikki Tuuri <Heikki.Tuuri--innodb.com> To: mysql--lists.mysql.com, bugs--lists.mysql.com Subject: Major bug fixed in InnoDB optimizer in ... WHERE col > x Date: 28 Jan 2003 01:52:49 +0200 Hi! Over the past 2 years several users have complained about optimization of queries of type ... WHERE col < x; ... WHERE col <= x; ... WHERE col > x; ... WHERE col >= x; and, indeed, there was a major bug in the InnoDB query estimator. The fix appears in 4.0.10 and 3.23.56. " MySQL/InnoDB-3.23.56, February xx, 2003 Fixed a major bug in InnoDB query optimization: queries of type SELECT ... WHERE indexcolumn < x and SELECT ... WHERE indexcolumn > x could cause a table scan even if the selectivity would have been very good. " Best regards, Heikki Innobase Oy For mail filters: How-to-Repeat: sql query