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 Employee
in General Discussion

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:

Answers

  • ybeiybei 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
Format
Heading 1Heading 2
QuoteCodeSpoiler
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 ...

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