- 13.7.2.1. Overview of Fast Index Creation
- 13.7.2.2. Examples of Fast Index Creation
- 13.7.2.3. Implementation Details of Fast Index Creation
- 13.7.2.4. Concurrency Considerations for Fast Index Creation
- 13.7.2.5. How Crash Recovery Works with Fast Index Creation
- 13.7.2.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.