Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Do projections need to be optimized after every load?

Do projections need to be optimized after every load?

Comments

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.