Reindl, >> The order of the WHERE clause does not matter > > that is simply not true > > otherwise that documentation would not exist > http://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html
Yes, the order of the columns in composite indexes *does matter*. This is a different question to what Christophe asked. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql