Using Database Designer to Optimize Specific Class of Queries in HP Vertica

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 …