MV_ AGGREGATED_ COLUMN_ USAGE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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