The SQL Tuning Advisor analyses high-volume SQL statements and offers tuning recommendations. The SQL Tuning Advisor provides advice in the form of precise SQL actions for tuning the SQL statements along with their expected performance benefits.
Open a New SQL Worksheet and prepare the SQL for which you want to run the SQL Tuning Advisor for and Press Ctrl + F12 or the icon
The output would be as below with the recommendations,
Statistics: In this analysis, objects with stale or missing statistics are identified and appropriate recommendations are made to remedy the problem.
SQL Profile: In this section, SQL Tuning advisor recommends to improve the execution plan by the generation of a SQL Profile, which is the optimized plan to be used for that SQL
Indexes: This recommends whether the SQL statement might benefit from an index. If necessary, new indexes that can significantly enhance query performances are identified and recommended.
Restructure SQL: In this analysis, relevant suggestions are made to restructure the selected SQL statements for improved performance.
In order to run the SQL Tuning advisor, user needs to have ‘ADVISOR’ and ADMINISTER SQL TUNING SET privilege.
Print This Post
Easy "water hack" burns 2 lbs OVERNIGHT
ReplyDeleteWell over 160 thousand men and women are hacking their diet with a easy and secret "liquid hack" to lose 1-2 lbs every night while they sleep.
It's painless and it works on everybody.
This is how you can do it yourself:
1) Take a glass and fill it with water half glass
2) Then use this awesome hack
and you'll become 1-2 lbs skinnier the very next day!