Is that possible make projection about view

HyeontaeJu

We wanna use a view which is joined multiple, but the speed is so low..
Is that possible make projection about view??

Jim_Knicely

You can only create projections on tables, but you can tune projections for joins!

Doc Pages:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/AnalyzingData/Optimizations/AvoidingResegmentationDuringJoins.htm
https://www.vertica.com/docs/latest/HTML/Content/Authoring/AnalyzingData/Optimizations/HashJoinsVs.MergeJoins.htm

Another option is a Vertica Flattened table where you eliminate the joins altogether at query time.

Doc Page:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTables.htm