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!
How can I set the sort order of a super projection?
How can I set the sort order of a super projection?
Maybe by setting the tables primary key to the desired sort order?
0
Comments
You specify the order by in the projection DDL.
https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATEPROJECTION.htm?Highlight=create%20projection
Projection order by helps query performance, you can read this doc to different considerations
https://my.vertica.com/kb/Redesigning-Projections-for-Query-Optimization/Content/BestPractices/Redesigning-Projections-for-Query-Optimization.htm?Highlight=projection
You can also look at hands on in vertica that talks about how to work with table and projections
https://my.vertica.com/get-started-vertica/creating-tables-projections/
Hope this helps.
Eugenia