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

SHOW INDEXES;

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:

SHOW INDEXES;

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