Skip to main content
Returns a table with a row for each Firebolt index defined in the current database, with columns containing information about each index as listed below. For more information regarding indexes, see information_schema.indexes.

Syntax

SHOW INDEXES;

Returns

The returned table has the following columns.
Column NameData TypeDescription
index_nameTEXTThe name defined for the index.
table_nameTEXTThe name of the table for which the index is defined.
typeTEXTOne of either primary or aggregating.
expressionTEXTThe part of the index statement that specifies the columns and any aggregations included in the index.
compressed_bytesTEXTThe compressed size of the index in human readable format.
uncompressed_bytesTEXTThe uncompressed size of the index in human readable format.
compression_ratioDECIMALThe compression ratio (<size_uncompressed>/<size_compressed>).
number_of_tabletsBIGINTThe number of tablets in the index.

Example

The following example returns information about indexes in the database queried:
SHOW INDEXES;
index_nametable_nametypeexpressionsize_compressedsize_uncompressedcompression_rationumber_of_tablets
player_aggregating_idxplayersaggregating[“last_name”,count(*)]819.98 KiB819.98 KiB11