Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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: