General vertica cost-benefit query question
I have a 5 billion rows main table (lets call it A) in my vertica db.
I need to add a currency amounts (euro, gbp, usd ) for every row. what would be "easier" for vertica while performing queries on this table:
1.Adding (3 calculated ) columns on the A table? Or
2.Creating a new table (B) and for each row in A have 3 columns in B ? and joining the 2 tables when query is performed?
What is the best cost -benefit vertica wise?
What would be the best way performance wise?
I hope I am clear with my question,
Many thanks in advance