> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the SHOW INDEXES command.

# SHOW INDEXES

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](/reference-sql/information-schema/indexes).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW INDEXES;
```

## Returns

The returned table has the following columns.

| Column Name         | Data Type | Description                                                                                            |
| :------------------ | :-------- | :----------------------------------------------------------------------------------------------------- |
| index\_name         | TEXT      | The name defined for the index.                                                                        |
| table\_name         | TEXT      | The name of the table for which the index is defined.                                                  |
| type                | TEXT      | One of either `primary` or `aggregating`.                                                              |
| expression          | TEXT      | The part of the index statement that specifies the columns and any aggregations included in the index. |
| compressed\_bytes   | TEXT      | The compressed size of the index in human readable format.                                             |
| uncompressed\_bytes | TEXT      | The uncompressed size of the index in human readable format.                                           |
| compression\_ratio  | DECIMAL   | The compression ratio (`<size_uncompressed>`/`<size_compressed>`).                                     |
| number\_of\_tablets | BIGINT    | The number of tablets in the index.                                                                    |

## Example

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW INDEXES;
```

| index\_name              | table\_name | type        | expression                | size\_compressed | size\_uncompressed | compression\_ratio | number\_of\_tablets |
| :----------------------- | :---------- | :---------- | :------------------------ | :--------------- | :----------------- | :----------------- | :------------------ |
| player\_aggregating\_idx | players     | aggregating | \["last\_name",count(\*)] | 819.98 KiB       | 819.98 KiB         | 1                  | 1                   |