DBD recommendations based on amount of data?

Is the amount of data in the tables important for the design recommendations made by DBD? In other words, does a large amount of data required for the DBD to make a good recommendation ?
Asked during BDC session Vertica Database Designer – Today and Tomorrow
@ybei
Tagged:
0
Answers
I think it makes a difference when it comes to recommending a projection that is unsegmented (which is recommended for smaller tables) vs a projection that is segmented. My personal rule of thumb is to default to an unsegmented projection on a table with less than 1 million rows. I am not sure exactly what amount the DBD uses when recommending one vs the other but I do believe itt takes itt into account for this purpose only.
Check out: