We have been sharing this query with the customers to have a quick health check on their environment. The query covers these items:
- Checking basic statistics information (actual row count vs row count for control node)
- Table data skew
- Small CCI tables (<102400 rows per partition) – This is just for their reference for reviewing their tables.
- CCI tables with more than 10% deleted rows
- CCI tables with smaller row groups
This script will drop the temp tables created at the end of the script.