Run the workload advisors to get recommendation for improving
the performance of SQL statements in a query workload.
About this task
The Workload Index Advisor and Workload Query Advisor require
up-to-date statistics for the database objects that are in the access
plans for the SQL statements that are in the workload. Before running
the Workload Index Advisor and Workload Query Advisor, run the Workload
Statistics Advisor and run the RUNSTATS command that it generates.