DELETE and UPDATE Queries

Vertica is optimized for query-intensive workloads, so DELETE and UPDATE queries might not achieve the same level of performance as other queries. A DELETE and UPDATE operation has to update all projections, so the operation is as slow as the slowest projection. For additional information, see Using INSERT, UPDATE, and DELETE.

The topics that follow discuss best practices for optimizing DELETE and UPDATE queries in Vertica.