Vertica Analytics Platform Version 9.2.x Documentation
Best Practices for DELETE and UPDATE
Vertica is optimized for query-intensive workloads, so
UPDATE queries might not achieve the same level of performance as other queries.
UPDATE operations go to the WOS by default, but if the data is sufficiently large and would not fit in memory, Vertica automatically switches to using the ROS. See Using INSERT, UPDATE, and DELETE.
The topics that follow discuss best practices when using
UPDATE operations in Vertica.
In This Section
Was this topic helpful?