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?

Answers

  • 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.
    https://www.brighttalk.com/webcast/8913/375431?utm_source=mfcom&utm_medium=mfcom&utm_campaign=00165138

    You can use projection_basename column to count the projections.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...