On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBois wrote: > At 14:14 +0700 7/9/03, Dominicus Donny wrote: > >Sorry, my mistake. It's "reindexing" then. > >Once i should add 2 key indexes on a huge table. > >But instead of alter the table in 1 single query, > >I build each index 1 by 1. > > Generally, it is faster to build all your indexes with a single > ALTER TABLE statement than to build them one by one with separate > ALTER TABLE statements.
Single. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 8 days, processed 247,399,591 queries (350/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]