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 tab
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
--
MySQL Gene
