How is the performance of Joins in Vertica?

edited October 2019 in General Discussion

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?

Best Answer

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.