Skip to main content
Question

Example of scenarios to not define a projection?

  • April 1, 2020
  • 1 reply
  • 9 views

Min_Yun_Chan

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

1 reply

ybei
Forum|alt.badge.img
  • Participating Frequently
  • April 2, 2020

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.