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 --------------------------------------------------------------------- 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
