Live Aggregate Projections

A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads—for example, through INSERTor COPYVertica recalculates aggregations with the new data and updates the projection.

DML operations on anchor tables are faster if the tables' load methods are set to DIRECT.

In This Section