How can I create an index on vertica?

Question

I created a table on Vertica. I want to create an index in this table. I can create an index on vertica. Is it possible? How can i do this? Can someone give me some sample scripts? Thanks.

Answer 1

Vertica's speed is based on the use of columnar ledges, not indexes. Please see: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12037.htm

So, in fact, Vertica is not able to create an index. You will need to use projection to achieve good performance.

Answer 2

Kimbo's answer is correct.

I try to explain this to people in several ways. But basically, the table itself is a design similar to a view. Unlike traditional databases, the table itself is not saved to disk and then indexed differently. Projections handle sorting, indexing, disk layout, etc.

I also use the deck of cards analogy. A table can be considered a deck of cards. You ask for special hands. Projection is like random shuffling. Some may be sorted by costume. Some at par. And depending on what you ask, it depends on what projection (in this similar shuffle) you request.