Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does the Automatic SQL Tuning feature perform other types of analysis besides SQL profiling?

April 26, 2017analysis automatic feature perform profiling sql tuning types

0

Posted

Does the Automatic SQL Tuning feature perform other types of analysis besides SQL profiling?

1 Answer

0

Posted

Yes– the Automatic SQL tuning feature provides all of the possible recommendations: gathering statistics on objects with missing/stale statistics, creating indexes, SQL Profiles, and SQL Restructure recommendations. However, only SQL Profiles are auto-implemented if they benefit the SQL statements significantly and a report is provided to the end-user to review other recommendations.