Hello.
ALTER TABLE works in the following way: Create a new table named A-xxx with the requested structural changes. Copy all rows from the original table to A-xxx. Rename the original table to B-xxx. Rename A-xxx to your original table name. Delete B-xxx. As ALTER table creates a new table, it rebuilds indexes. CheHax <[EMAIL PROTECTED]> wrote: > Hello list, > > I have a big table, 25M records and a lot of indexes on it. > Sometimes, it happens that we need to create an new index on the > table, and I was wondering if there is a solution to do an > ALTER TABLE... ADD INDEX without having mySQL to rebuild all indexes ? > > Thanks, > CheHax > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]