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.

Last modified: August 29, 2022

Was this article helpful?