Check out the SQL Tuning Health-Check Script
The SQL Tuning Health-Check Script also known as SQLHC, is used to check the environment in which a single SQL Statement runs, checking Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters and other elements that may influence the performance of the one SQL being analyzed.
To learn more, please review this 3 minute video of the SQL Tuning Health-Check Script (Note ID: 1455583.1)
To learn more, please review this 3 minute video of the SQL Tuning Health-Check Script (Note ID: 1455583.1)
1