Re: Double Index Performance

[Sebastien Caisse]

http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

To find the MIN() or MAX() value for a specific indexed column key_col. This is optimized by a preprocessor that checks whether you are using WHERE key_part_N = constant on all key parts that occur before key_col in the index. In this case, MySQL does a single key lookup for each MIN() or MAX() expression and replaces it with a constant. If all expressions are replaced with constants, the query returns at once.

In effect, I was sooo wrong :). Well, live, learn and get better!