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.
Is it better to combine multiple fact tables with a primary key or with a merge operation? @bat @rbankula
From Optimizing Query Performance and Resource Pool Tuning.
Keep them separate. Pick one of them as your main table and extend that with the columns of the other table with the https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTables.htm feature.
Answers
Keep them separate.
Pick one of them as your main table and extend that with the columns of the other table with the https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTables.htm feature.