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.

Syntax

SHOW INDEXES;

Returns

The returned table has the following columns.

Column nameData TypeDescription
index_nameTEXTThe name of the index.
table_nameTEXTThe name of the table associated with the index.
typeTEXTOne of primary or aggregating.
expressionARRAY (TEXT)An ordered array of the expression in SQL that defined the index.
size_compressedDOUBLE PRECISIONThe size of the index in bytes.
size_uncompressedDOUBLE PRECISIONThe uncompressed size of the index in bytes.
compression_ratioDOUBLE PRECISIONThe compression ratio (<size_uncompressed>/<size_compressed>).
number_of_segmentsINTEGERThe number of segments comprising the table.

Example

The following example returns information about indexes in the database queried:

SHOW INDEXES;
index_nametable_nametypeexpressionsize_compressedsize_uncompressedcompression_rationumber_of_tablets
players_join_idxplayersjoin[“playerid”,“nickname”,“email”,“agecategory”]819.98 KiB819.98 KiB10