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
How can I set the sort order of a super projection?
Maybe by setting the tables primary key to the desired sort order?
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