Does TRUNCATE work on a merge table? I honestly don't know, but it should be faster than a DELETE for removing all of the records.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 20, 2007 4:13 PM > To: mysql@lists.mysql.com > Subject: Why is Delete slow on a Merge Table? > > I have a merge table that is a union of 20 1 million row tables. Select > rows from it is quite fast. However if I want to delete all the rows as > in: > > delete from MyMergeTable; > > it takes just over 3 minutes. I could execute 20 separate delete > statements > for each of the 20 tables and it would complete in under a second. Why > is a > Delete on a merge table so inefficient? It appears it is deleting all > the > rows individually. > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]