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


Example of scenarios to not define a projection? — Vertica Forum

Example of scenarios to not define a projection?

Min_Yun_ChanMin_Yun_Chan Vertica Employee 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 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
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 ...