Best Practices for DELETE and UPDATE

Vertica is optimized for query-intensive workloads, so DELETE and UPDATE queries might not achieve the same level of performance as other queries. DELETE and 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 DELETE and UPDATE operations in Vertica.