The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Most Efficient way to update one column

Hello,

 

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? 

Comments

Leave a Comment

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