Prepare the database account for implementation of SQL Access Advisor recommendations.
Use a STS as the workload and create a SQL Access Advisor task.
View recommendations produced by the advisor and implement these.
Confirm by various means that the recommendations were properly implemented.
Launch a Quick Tune session and review the recommendations.
SQL ACCESS-1
Using an administrator account, grant the owner of the application schema the privileges needed to create and use a materialized view. In this way, in the event that the SQL Access Advisor recommends materialized view objects, one will be able to implement those recommendations automatically.
SQL ACCESS-2
You are currently reading a PREVIEW of this book.
Get instant access to over
$1 million worth of books and videos.
