Avoid 1:1 Relationships in Your Data Model
Jim Knicely, Vertica Field Chief Technologist
July 24, 2019
1:1 relationships exist in row-oriented databases because of performance concerns. As a columnar database, there is no reason in Vertica to separate large tables out into separate structures. That is, instead of joining two large fact tables together, combine them into a single table! Helpful Links: Have fun!