How is the performance of Joins in Vertica?
I heard that joins in Vertica a bit expensive. Is this true?
We're designing the table's schema for our project and for fields which can have multiple values- we are planning to store them in a separate table which can be JOINed with the main table to reflect one-many relationship- thats what a standard practice in SQL. Is this good to follow in Vertica too without any major performance loss?