Metadata commands
SHOW INDEXES
Reference and syntax for the SHOW INDEXES command.
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
Returns
The returned table has the following columns.
Column name | Data Type | Description |
---|---|---|
index_name | TEXT | The name of the index. |
table_name | TEXT | The name of the table associated with the index. |
type | TEXT | One of primary or aggregating . |
expression | ARRAY (TEXT) | An ordered array of the expression in SQL that defined the index. |
size_compressed | DOUBLE PRECISION | The size of the index in bytes. |
size_uncompressed | DOUBLE PRECISION | The uncompressed size of the index in bytes. |
compression_ratio | DOUBLE PRECISION | The compression ratio (<size_uncompressed> /<size_compressed> ). |
number_of_segments | INTEGER | The number of segments comprising the table. |
Example
The following example returns information about indexes in the database queried:
index_name | table_name | type | expression | size_compressed | size_uncompressed | compression_ratio | number_of_tablets |
---|---|---|---|---|---|---|---|
players_join_idx | players | join | [“playerid”,“nickname”,“email”,“agecategory”] | 819.98 KiB | 819.98 KiB | 1 | 0 |