# CORRELATED\_COLUMN\_STATISTICS

This view contains information about correlated columns.

| Column Name              | Description                                                                         |
| ------------------------ | ----------------------------------------------------------------------------------- |
| `DATABASE_NAME`          | The name of the related database.                                                   |
| `TABLE_NAME`             | The name of the related table.                                                      |
| `CORRELATED_COLUMN_NAME` | The name of column that is positively correlated to another (called the correllee). |
| `CORALLEE_COLUMN_NAME`   | The name of the corallee column (see`CORRELATED_COLUMN_NAME`).                      |
| `CORRELATION_COEFF`      | The correlation coefficient (between 0 ... 1).                                      |

***

Modified at: January 4, 2024

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

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