The Vertica update query running on a table with 500 columns takes hours to finish. The performance of update query cannot be predicted
Environment
Vertica Analytics Database: All versions
Situation
How to optimize an update query in Vertica which takes several hours to finish. The table being updated has 500 columns.