how to drop previous recommendations from Automatic SQL Tuning
Hi,Automatic SQL Tuning runs in the database every day, and creates a report with recommendations every day. We can not accept all recommendations, and after the first time, where there is actual recommendation was made, every subsequent time, those statements are under "Miscellaneous" category. The only thing it says is :
This statement was skipped because it has already been tuned recently. See task execution "EXEC_35908" for the most recent tuning results.
How can I drop all those old executions and recommendations and get the SQL Tuning job create new recommendations and not relay on the old recommendations? Kind of, "start fresh, and make all recommendations now".
This statement was skipped because it has already been tuned recently. See task execution "EXEC_35908" for the most recent tuning results.
How can I drop all those old executions and recommendations and get the SQL Tuning job create new recommendations and not relay on the old recommendations? Kind of, "start fresh, and make all recommendations now".
0