Most Efficient way to update one column



I have a very large table. (120 million rows +). I want to update all the values in a single column.


what is the most efficient way of doing this?


I was thinking that I will create another table and then issue a update query based on join.


Is there a better / faster way? 


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file