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?
0
Comments
Hi
Many factors are missing in your post , like your cluster setup / amount of projections /amount of columns .
For large must delete / update operations "rebuilding Table approch" (in the same time set the new values to the column ) is the one you like to go with , you need to considure the netwrok and disk storage impcats that will take place during the execution of sucg process .
https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/AdministratorsGuide/ManageDiskSpace/RebuildingATable.htm.
Thanks