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
`database_name`	The name of the database, or `NULL` if none could be assigned.
`table_name`	The name of the table to which the column belongs.
`column_name`	The aggregated column information is displayed for this column.
`equijoins`	The number of equijoins this column has been involved in over all queries run over the table.
`inequality_joins`	The number of inequality joins this column has been involved in over all queries run over the table.
`equality_preds`	The number of equality predicates in the `WHERE` or `ON` clause this column has been involved in all queries run on the table.
`inequality_preds`	The number of inequality predicates in the `WHERE` or `ON` clause this column has been involved in all queries run on the table.
`groupbys`	The number of `GROUP BY` clause in the column involved in all queries run on the table.
`reshuffles`	The number of reshuffle key in the column, involved in all queries run on the table.
`orderbys`	The number of `ORDER BY` clause in the column involved in all queries run on the table.
`outputs`	The number of times the column was returned as the result of a query.
`query_appearances`	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.

Was this article helpful?