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
Mysql,
Is there any difference between
alter table test add index(id, lastname);
alter table test add index(zip5, zip4);
and
alter table test add index(id, lastname), add index(zip5, zip4);
The test table has 90 millions records.
Thanks.
--
MySQL General Mailing List
For list archives: ht
