One of our customer wants to know if we have any recommendation on order of columns for PK. They want to know if the order of the columns is important and if yes what is the optimal order.
Vertica documentation doesn't discuss anything on this topic. However, we know that Vertica creates special key projections to enforce primary keys and the projections are sorted and segmented on the PK columns, in the same order as they are defined.
Considering this, does it mean that we should use the same guidelines for PK column order as for choosing projection sort order? e.g. put low cardinality column first, for same cardinality put column with smaller size first etc?
Anybody has any ideas/recommendation?
Thank you,
Pravesh
