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.