TIA
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
I am importing data into a large table, 100 million rows, and I want to use
"Alter table disable keys" prior to executing a Load Data...,. But after
loading the data, if I execute a "Alter Table ... enable keys" will MySQL
create a second table, load the data into the second table, and then
rebuild the keys like it does for most Alter Tables? I don't want to use
Alter Table ... if it is going to copy the data over to another table. I'm
thinking MySQL should be smart enough just to rebuild the index without
moving data. Am I right?
