MV_AGGREGATED_COLUMN_USAGE
This view provides a summary of mv_query_column_usage
, aggregating over the columns over all queries run.
Column name | Description |
---|---|
| The name of the database, or |
| The name of the table to which the column belongs. |
| The aggregated column information is displayed for this column. |
| The number of equijoins this column has been involved in over all queries run over the table. |
| The number of inequality joins this column has been involved in over all queries run over the table. |
| The number of equality predicates in the |
| The number of inequality predicates in the |
| The number of |
| The number of reshuffle key in the column, involved in all queries run on the table. |
| The number of |
| The number of times the column was returned as the result of a query. |
| The number of distinct queries the column appears in all queries run on the table, which is equivalent to the number of times the column appears in the first table. |