Do projections need to be optimized after every load?

Old_CommunityOld_Community
in General Discussion
Do projections need to be optimized after every load?

Comments

  • Old_CommunityOld_Community
    No, projections are typically designed once, up front, before going to production. Once optimized projections exist, when a table is loaded, all associated projections physically store a copy of the loaded data. Projections are the only physical data storage format in Vertica and are maintained automatically.

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 ...