DELETE and UPDATE Performance Considerations

To improve the performance of your DELETE and UPDATE queries, consider the following issues:

For detailed tips about improving DELETE and UPDATE performance, see DELETE and UPDATE Optimization.

Caution: Vertica does not remove deleted data immediately but keeps it as history for the purposes of historical query. A large amount of history can result in slower query performance. For information about how to configure the appropriate amount of history to retain, see Purging Deleted Data.