Bulk updation

I am trying to update 2 columns of a table having 40 fields and 9 million records. Presently I am doing this in parts (based on values on key values). Would it be faster if a table is locked before trying the updation ?? Any other techniques ??

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 02 1998 - 21:22:55 CDT