May 24, 2012

Post: Getting MySQL to use full key length

largest extent possible: mysql> explain SELECT thread_id FROM nn2_msg132.msg132 force index(group_id) WHERE groupsecond query is accessing subset of rows from the first plan so estimation for number of rows for the first query