Search code examples
vertica

Vertica: how to know what indexes a table has?

Let's say I have a table in Vertica database named "my_table" and I want to run a query that will tell me what indexes exist on this table. How can I do it?

Solution

  • There are no such things as indexes in Vertica. Each table has projections (Physical Schema, Working with Projections).

    To see what projections a table has, run the following query:

    SELECT *
FROM projections
WHERE anchor_table_name = 'my_table';