Your journey to database proficiency
Tool Included in Vertica install to help with schema design
A lot of people who are new to Vertica ask if you can create an index on a table in a Vertica database. The answer they get is NO. Vertica does not have a CREATE INDEX statement and does not have the concept of an index. Let’s see if we can come up with something Read More …
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 …
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 …
