Options
Is that possible make projection about view
HyeontaeJu
Vertica Customer ✭
We wanna use a view which is joined multiple, but the speed is so low..
Is that possible make projection about view??
0
Best Answer
-
Options
Jim_Knicely
- Select Field - Administrator
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.htmAnother option is a Vertica Flattened table where you eliminate the joins altogether at query time.
5