Information schema for indexes

You can use the information_schema.indexes view to return information about each index in a database. The view is available for each database and contains one row for each index in the database. You can use a SELECT query to return information about each index.

The following query returns all aggregating indexes defined within the current database

SELECT
  *
FROM
  information_schema.indexes
WHERE
  index_type='aggregating`;

Columns in information_schema.indexes

Each row has the following columns with information about the database.

Name	Data Type	Description
table_catalog	STRING	Name of the catalog. Firebolt provides a single ‘default’ catalog.
table_schema	STRING	Name of the database.
table_name	STRING	The name of the table for which the index is defined.
index_name	STRING	The name defined for the index.
index_type	STRING	One of `primary`, `aggregating`, or `join`.
index_definition	STRING	The portion of the index statement that defines the columns and aggregations (if applicable) for the index.
_index_compressed_size	BIGINT	The compressed size of the index.
index_uncompressed_size	BIGINT	The uncompressed size of the index.