OPTIMIZER_ STATISTICS
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 column statistics calculated on columns when a table is processed by autostats or the ANALYZE
command.
It displays one row per column per table.
Column Name |
Description |
---|---|
|
The name of the related database. |
|
The name of the related table. |
|
The name of the related column. |
|
The number of rows in a given table. |
|
The number of |
|
The number of unique values stored within a given column. |
|
Whether or not autostats are currently enabled for a given column. |
|
Whether or not autostats are considered too out-of-date to be used currently. |
|
This column is deprecated and no longer used and its value is always |
|
This column is deprecated and no longer used and its value is always |
|
This column is deprecated and no longer used and its value is always |
|
Whether advanced histograms are collected on this column. |
|
Whether legacy histograms are collected on this column. |
|
Whether histograms (of either type) are collected on this column . |
|
The sample size collected to build histograms on this column. |
|
The timestamp at which autostats were last updated for a given column. |
Last modified: August 29, 2022