14.3.14 InnoDB Fast Index Creation

14.3.14.1 Overview of Fast Index Creation
14.3.14.2 Examples of Fast Index Creation
14.3.14.3 Implementation Details of Fast Index Creation
14.3.14.4 Concurrency Considerations for Fast Index Creation
14.3.14.5 How Crash Recovery Works with Fast Index Creation
14.3.14.6 Limitations of Fast Index Creation

In MySQL 5.5 and higher, or in MySQL 5.1 with the InnoDB Plugin, creating and dropping secondary indexes does not copy the contents of the entire table, making this operation much more efficient than with prior releases.