MV_ PROSPECTIVE_ HISTOGRAMS
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 contains information about columns which were used in queries where a histogram could have been utilized, but did not have histograms.
This view counts over all queries (rows) in the in-memory plancache in order to distinguish which of these contain applicable columns.
Column Name |
Description |
---|---|
|
The name of the related database. |
|
The name of the related table. |
|
The name of a given column for which a prospective histogram has been identified. |
|
When there is a histogram on a json_ |
|
The number of times the column was used in queries where a histogram could have been utilized, counting once per query per occurrence of the table. |
Last modified: January 5, 2024