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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/indexes",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> 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](/overview/security/rbac/database-permissions/schema-permissions#schema-level-privileges) and the [database](/overview/security/rbac/database-permissions#database-level-privileges). You also need ownership of the table or the necessary [table-level privileges](/overview/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":"github-light","dark":"github-dark"}}
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.                                                                       |