How many projections are recommended per table?

HyeontaeJuHyeontaeJu Vertica Customer
edited September 2020 in General Discussion

How many projections per table do you recommend?
And Which column in 'projections' table, projection_name or projection_basename, counts projection?


  • Options
    HibikiHibiki Vertica Employee Employee

    It depends on your business requirements. One table has to have at least one super projection. You can create any projections to optimize your queries. But the additional projection will incur a system resource cost, contribute to catalog size and impact performance. But this is not a mandatory condition because we may see the cases it should create more than 8 projections to achieve the business requirements.

    If you need the information about Vertica Advisor, please refer to the following link.

    You can use projection_basename column to count the projections.

Leave a Comment

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