> ## 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.

> Use this reference to learn about the metadata available for Firebolt indexes using the information schema.

# Indexes

You can use the `information_schema.indexes` view to return information about each index in a database. The view is available for each database and contains one row for each index in the database. You can use a `SELECT` query to return information about each index.

In order to view index information, you need the USAGE privilege on both the [schema](/security/rbac/database-permissions/schema-permissions#schema-level-privileges) and the [database](/security/rbac/database-permissions#database-level-privileges). You also need ownership of the table or the necessary [table-level privileges](/security/rbac/database-permissions/table-permissions#table-level-privileges) required for the intended action.

The following query returns all aggregating indexes defined within the current database.

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  *
FROM
  information_schema.indexes
WHERE
  index_type='aggregating`;
```

## Columns in information\_schema.indexes

Each row has the following columns with information about the database.

| Column Name | Data Type | Description |
| :- | :- | :- |
| table\_catalog | TEXT | Name of the catalog. Firebolt provides a single ‘default’ catalog. |
| table\_schema | TEXT | Name of the database. |
| table\_name | TEXT | The name of the table for which the index is defined. |
| index\_name | TEXT | The name defined for the index. |
| index\_type | TEXT | One of either `primary` or `aggregating`. |
| index\_owner | TEXT | The owner of the index. |
| index\_origin | TEXT | Index creation origin: 'USER' or 'SYSTEM' or NULL if not applicable |
| index\_definition | TEXT | The part of the index statement that specifies the columns and any aggregations included in the index. |
| compressed\_bytes | BIGINT | The compressed size of the index, in bytes. |
| uncompressed\_bytes | BIGINT | The uncompressed size of the index, in bytes. |
| number\_of\_tablets | BIGINT | The number of tablets in the index. |
| created | TIMESTAMPTZ | Time that the index was created. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.