The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How do aggregate projections affect the load performance?

Answers

  • marcothesanemarcothesane - Select Field - Administrator

    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