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_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
Tagged:
0
Answers
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.