The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Example of scenarios to not define a projection?

Min_Yun_ChanMin_Yun_Chan Vertica Employee Employee

Can you explain some possible scenarios in which you would NOT want to define a projection?

Question from The shortest path to Vertica: Best practices for data warehouse migration & ETL
@marcothesane @Maurizio


  • ybeiybei Vertica Employee Employee

    even if you don't want to use the projection's sort order / segmentation benefit, it is still beneficial to sort so that encodings can benefit.

Leave a Comment

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