SHOW STATS#
Synopsis#
SHOW STATS FOR table
SHOW STATS FOR ( query )
Description#
Returns approximated statistics for the named table or for the results of a
query. Returns NULL
for any statistics that are not populated or
unavailable on the data source.
Statistics are returned as a row for each column, plus a summary row for
the table (identifiable by a NULL
value for column_name
). The following
table lists the returned columns and what statistics they represent. Any
additional statistics collected on the data source, other than those listed
here, are not included.
Column |
Description |
Notes |
---|---|---|
|
The name of the column |
|
|
The total size in bytes of all of the values in the column |
|
|
The estimated number of distinct values in the column |
|
|
The portion of the values in the column that are |
|
|
The estimated number of rows in the table |
|
|
The lowest value found in this column |
|
|
The highest value found in this column |
|