Mysql add multiple index

[Vivian Wang]

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: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]