How to Use UDx to Extend Vertica Live Aggregate Projections
Maurizio Felici, Field Chief Technologist
August 8, 2023
Thanks to its sophisticated optimizer and extremely efficient query engine Vertica can process data aggregations order of magnitudes faster than traditional Database Management Systems. To further boost data aggregation performance, we can use Vertica’s Live Aggregate Projections (LAP from now on). The concept is very simple: pre-aggregate data once during load operations rather than doing...