Can Smallish ref tables have full data on each node? To improve join performance?
What is the best way to define tables (specifically the partitions) for reference tables. Since these tables will be used often in joins on tables with various (mostly date based) partition clause. I worry about the effect on performance. Many times we try to flatten tables in vertica but sometimes this is impractical and we want a join.