Me again...
in the Certification Study Guide it is writen that is more efficient to add
2 (or many) indexes at a time then adding them individualy... but they don't
say why !
I stand by my initial advice:
*If you can afford a lock on the table to last a little longer you can go
with creat
If you can afford a lock on the table to last a little longer you can go
with creating the 2 indexes at once.
If not create the one by one... i'm sure some other queries will be honoured
between those ALTER statements.
From MySQL 4.0 we have:
ALTER TABLE ... DISABLE KEYS
and
ALTER TABLE ... EN
