DISABLE / ENABLE keys is very fast even for your dataset. Basically when disabled it only respects UNIQUE type keys when loading data and rebalances the binary tree when enabled.
Dathan > -----Original Message----- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 5:24 PM > To: mysql@lists.mysql.com > Subject: Will "Alter Table ... enable keys" reload data to table? > > 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? > > TIA > > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
