We wanna use a view which is joined multiple, but the speed is so low..
Is that possible make projection about view??
Question
Is that possible make projection about view
+2
+2You 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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
