Using Database Designer to Build Projections with Optimal Sort Order in HP Vertica
The performance level of your queries in Vertica depend on the design of your projections. In the projection definitions you specify how your data will be segmented and how your data will be sorted. If you are going to make the right choices your queries will perform really well. I covered projection segmentation in my Read More …