We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Do projections need to be optimized after every load? — Vertica Forum

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