Hello. See:
http://dev.mysql.com/doc/mysql/en/LIMIT_optimization.html > >"Jeremiah Gowdy" <[EMAIL PROTECTED]> wrote: >Can anyone tell me why this makes sense? I have a SELECT which uses an >indexed datetime >field called Start with a BETWEEN range. If I select on this with no LIMIT, >it does a >full scan of the 9391282 records in the DB (key=NULL). However, if I do a >limit of any >value LESS than the number of records in the DB, it uses the index >(key=Start). If I do >a LIMIT of any value greater than the number of records in the DB it again >doesn't use >the index (key=NULL). > >>>>This is on MySQL 4.0.18. Am I missing a bug fix in a more recent version >>>>of MySQL? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]