Re: Mysql optimisation

1. mySQL DBA: Indexes, the optimizer, and doing efficent selects
   choonkeat 28-Aug-2008

   Notice that A,C does not use 2 bytes of the index making the lookup scan the result set of A, since A,C doesn't follow left-most in the compound index C comes after B ;)) ^{link »}

   tags: aug 08, mysqldba.blogspot.com, mysql optimisation

   http://mysqldba.blogspot.com/2006/08/indexes-optimizer-and-doing-efficent.html · Original page

   ^[»] embed