We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Is that possible make projection about view — Vertica Forum

Is that possible make projection about view

HyeontaeJu

HyeontaeJu Vertica Customer ✭

September 2020 in General Discussion

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

Jim_Knicely - Select Field - Administrator

September 2020 edited September 2020 Answer ✓

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

5

Leave a Comment