# STATISTICS

This view contains statistics about table indexes. It displays one row per column per index.

| Column Name     | Description                                                                                                                                                      |
| --------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `TABLE_CATALOG` | This value is always`def`.                                                                                                                                       |
| `TABLE_SCHEMA`  | The name of the related schema (database) that a given table belongs to.                                                                                         |
| `TABLE_NAME`    | The name of the related table for a given index.                                                                                                                 |
| `NON_UNIQUE`    | If the index can contain duplicates, this is`1`. If the index cannot contain duplicates, this is`0`.                                                             |
| `INDEX_SCHEMA`  | The name of the schema (database) that a given index belongs to. This value is the same as`TABLE_SCHEMA`.                                                        |
| `INDEX_NAME`    | The name of a given index. This is`primary`if the index is a primary key.                                                                                        |
| `SEQ_IN_INDEX`  | The sequential number of a column within a given index.                                                                                                          |
| `COLUMN_NAME`   | The name of a column within a given index.                                                                                                                       |
| `COLLATION`     | If a given column is sorted ascending within an index, this value is`A`. If the column is sorted descending, it is`D`. If the column is not sorted, it is`NULL`. |
| `CARDINALITY`   | This column is unused and is present only for compatibility reasons, its value is always`0`.                                                                     |
| `SUB_PART`      | This column is unused and is present only for compatibility reasons, its value is always`NULL`.                                                                  |
| `PACKED`        | This column is unused and is present only for compatibility reasons, its value is always`NULL`.                                                                  |
| `NULLABLE`      | Whether a given column can contain`NULL`values.                                                                                                                  |
| `INDEX_TYPE`    | The type of index.                                                                                                                                               |
| `COMMENT`       | This column is unused and is present only for compatibility reasons, its value is always empty.                                                                  |
| `INDEX_COMMENT` | This column is unused and is present only for compatibility reasons, its value is always empty.                                                                  |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/statistics/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/query-performance-workload-management-and-statistics/statistics/)

(An index of the documentation is available at /llms.txt)