On Fri, Mar 02, 2001 at 09:27:50AM +1300, Quentin Bennett wrote:
> Hi,
>
> Would
>
> ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol);
>
> do this in one sweep of the table, creating one temporary copy, or go
> through the table twice, one for each index?
>
One run for the entire ALTER TABLE.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
