Which four types of recommendations do you get from Automatic Tuning Optimizer (ATO) via the STA?

You are using SQL Tuning Advisor (STA) to tune SQL workload in your database. Which
four types of recommendations do you get from Automatic Tuning Optimizer (ATO) via the
STA? (Choose four.)

You are using SQL Tuning Advisor (STA) to tune SQL workload in your database. Which
four types of recommendations do you get from Automatic Tuning Optimizer (ATO) via the
STA? (Choose four.)

A.
recommendation todenormalize the schema

B.
recommendation to use stored outlines

C.
recommendation to create indexes

D.
recommendation to gather relevant statistics

E.
recommendation to create a SQL profile

F.
recommendation to restructure SQL statements



Leave a Reply 0

Your email address will not be published. Required fields are marked *