From: Perrin Harkins Date: August 20 2009 2:51pm Subject: Re: Simple join very slow List-Archive: http://lists.mysql.com/mysql/218445 Message-Id: <66887a3d0908200751u63b6adc2mcecc0d753e176d4d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Thu, Aug 20, 2009 at 10:43 AM, Johnny Withers wrote: > MySQL can only use one index at a time. That was fixed years ago, in MySQL 5.0. http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html - Perrin