Can I create an index on a table in Vertica?

vertica
user1474138 picture user1474138 · Jul 27, 2013 · Viewed 8.8k times · Source

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?

Answer

kimbo305 picture kimbo305 · Jul 28, 2013

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.

Related questions

SQL left outer join on multiple columns

According to this SQL join cheat-sheet, a left outer join on one column is the following : SELECT * FROM a LEFT JOIN b ON a.foo = b.foo WHERE b.foo IS NULL I'm wondering what it would look like with …

Read More
Advantages of databases like Greenplum or Vertica compared to MongoDB or Cassandra

I am currently working in a few projects with MongoDB and Apache Cassandra respectively. I am also using Solr a lot and I am handling "lots" of data with them (approx. 1-2TB). I've heard of Greenplum and Vertica the …

Read More
unixODBC giving error while running isql [Vertica]

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and I have cross checked them. Here is my odbc.ini file: [VerticaDSN] Description = VerticaDSN ODBC driver Driver = /opt/vertica/lib/…

Read More