Somebody mentioned the CREATE INDEX WITH DROP EXISTING, and I remember trying that and the answer is yes... and in EE you can do it online... it's pretty sweet... except the necessity of dropping all primary and foreign keys.

At the end of the day you need to do it offline so as to keep referential integrity.

pity.