MV_ QUERY_ 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 information about the usage of columns by queries in the workload.
Details about column that are used in joins, filters, group-bys, order-bys or reshuffles help to understand the frequency and cost of use of columns, and make better decisions about indexing and sharding of data.
Column name |
Description |
---|---|
|
The ID associated with the query. |
|
The name of the database, or |
|
The name of the table in the query. |
|
The name of the column that exists in the table. |
|
The number of times this column was involved in an equijoin in the query. |
|
The number of times the column was involved in a non-equijoin in the query. |
|
The number of times the column was involved in equality predicates in the |
|
The number of times the column was involved in inequality predicates in the |
|
The number of times the column was involved in a |
|
The number of times the column was involved in a |
|
The number of times the column was member of reshuffle key in the query. |
|
The number of times the column was returned as the result of the query. |
Last modified: August 29, 2022