Building Projections with Optimal Segmentation in HP Vertica

Posted onLeave a comment

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. In this post we will look Read More …

Optimizing Storage Footprint in HP Vertica with Database Designer

Posted onLeave a comment

One of Vertica’s unique features is encoding. Encoding is an attribute, which you can specify in the column definition in your CREATE PROJECTION statement. This attribute is optional. If you omit it Vertica will use default encoding with the name AUTO. AUTO encoding is made to be universal and as any universal thing it is Read More …