Can I create an index on a table in Vertica?

vertica

Solution

Vertica's speed is hinged on using columnar projections, not indexes. Please see: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12037.htm

So, in fact, Vertica doesn't have the ability to create an index. You will have to use a projection to achieve good performance.

Problem

I've created a table on Vertica, and I want to create an index on that table. I can't see how to create an index on Vertica, though. Is it possible? If so, how can I do that?

Original source