# View Table Statistics (Continue...)
+ Check the health status of the table:
```
mysql> SHOW STATS_HEALTHY WHERE db_name = 'tpcc' AND table_name = 'orders';
+---------+------------+----------------+---------+
| Db_name | Table_name | Partition_name | Healthy |
+---------+------------+----------------+---------+
| tpcc    | orders     |                |      50 |
+---------+------------+----------------+---------+
1 row in set (0.00 sec)
```
------------------------------------------------------------
View statistics for a table
View various statistics for a table
- View the metadata of the table SHOW STATS_META [showLikeOrWhere];
- Check the health status of the table SHOW STATS_HEALTHY [showLikeOrWhere];
- View the metadata of the column SHOW STATS_HISTORWHERE [showLikeOrWhere];
View the information of the histogram SHOW STATS_BUCKETS [showLikeOrWhere];
```
mysql> SHOW STATS_HEALTHY WHERE db_name = 'tpcc' AND table_name = 'orders';
+---------+------------+----------------+---------+
| Db_name | Table_name | Partition_name | Healthy |
+---------+------------+----------------+---------+
| tpcc    | orders     |                |      50 |
+---------+------------+----------------+---------+
1 row in set (0.00 sec)
```
- You can view information such as the total number of rows in the table and the number of rows modify by SHOW STATS_META.
- You can check the health of the statistics by SHOW STAT_HEALTHY and coarse filter whether the statistics on the estimate table are accurate. When the health level falls below the automatic update threshold tidb_auto_analyze_ratio mentioned earlier, the optimizer automatically collects statistics within the window period
- You can view information such as the number of different values and the number of nulls in a column by SHOW STATS_HISTORIES. The statement outputs information such as the number of distinct values and the number of nulls for all columns.
- You can view information for each bucket in the histogram via STAT_BUCKETS. From this example, we can see that there is not only the histogram information for the table, but also the histogram information for the index.