OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Question about DELETE

From: Price, Randall (Randall.Pricevt.edu)
Date: Wed Mar 17 2010 - 14:51:35 CDT

Hello,

I have a simple question about deleting records from INNODB tables. I have a master table with a few child tables linked via Foreign Key constraints. Each table has several indexes as well.

My question is: if I delete many records in a single delete statement (i.e., DELETE FROM table WHERE id = 1 AND id = 5 ... AND ID = 100) how many times are the foreign keys/indexes updated?

Once for the entire DELETE operation or one time for each record that is deleted?

Thanks,

Randall Price