Skip to main content
Question

Best practices when combining multiple fact tables?

  • Apr 1, 2020 12:53 PM UTC
  • 1 reply
  • 7 views
rjs_docs

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.

    1 reply

    baron42bba
    Forum|alt.badge.img
    • baron42bba
    • Participating Frequently
    • Apr 1, 2020 6:45 PM UTC

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement