MV_ AGGREGATED_ COLUMN_ USAGE
This view provides a summary of mv_
, 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. |
Last modified: August 29, 2022