8.5 Optimization and Indexes

8.5.1 Column Indexes
8.5.2 Multiple-Column Indexes
8.5.3 How MySQL Uses Indexes
8.5.4 InnoDB and MyISAM Index Statistics Collection