LifeinAsia - 3:47 pm on Jan 13, 2013 (gmt 0)

B) - Isn't it better to use TRUNCATE TABLE?

TRUNCATE TABLE removes ALL the data in the table. That negates the whole point of doing the update chunks at a time.