What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

B

Can you check this.. it looks like SQL statement restructure recommendations is correct

https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDIBFGA

17.2 SQL Tuning Advisor
The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit. The recommendation relates to collection of statistics on objects, creation of new indexes, restructuring of the SQL statement, or creation of a SQL profile. You can choose to accept the recommendation to complete the tuning of the SQL statements. (There are only recommendation, not automated by left as optional)

Further it says what can be automated , in the continuation below

Oracle Database can automatically tune SQL statements by identifying problematic SQL statements and implementing tuning recommendations using the SQL Tuning Advisor during system maintenance windows. You can also run the SQL Tuning Advisor selectively on a single or a set of SQL statements that have been identified as problematic.