----- Original Message ----- > From: "Hank" <hes...@gmail.com> > > Just an update. Using the "load index into cache" statement for the > 200 million row indexed "source" table, my correlated update > statement ran in 1 hour, 45 minutes to update 144 million rows. A 50% > increase in performance!
Good to hear :-) Ignore leaves might be a nice trick in this situation, actually. I never thought of it, but the leaves contain the record pointers, which you don't need because you have a covering index. Nice thinking :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org