Hi,
I need to design a new DB.
In the new DB I have two fact tables
1st table is populated with events that were triggered recently.
2nd table is populated with events related to the 1st table in a delay of few days to a month.
There is a column (Item ID) that is in common to both tables (many to many relation. that column is only part of the primary key).
There will probably be many queries that need to join these two tables.
I can create a projection for each table sorted by that column (Item ID).
I would like to avoid performance issues.
Is there a way I can enforce distribution of the data among nodes to make sure that data for the same item ID is going to reside on the same node on both projections?
Thanks in advance
Data distribution among nodes
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Data distribution among nodes
I think you might be looking for identically segmented projections.
Checkout vertica.tips for more Vertica resources.