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.