How do aggregate projections affect the load performance?

Answers

  • They affect the load performance like any additional projection.
    If you come from another database than, think of adding indexes, and the effect of that - or , for DBMSs that support that, incrementally updating an aggregate Materialized View.
    So if you update your base table once a day and run one aggregate report once a day, you might not want to do it. But if you have hundreds of reports daily needing the pre-aggregated data, you will gladly invest the additional workload at load time.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.