Automatic Tuning Options for Enhanced Database Performance
Question
Automatic tuning continuously monitors the queries executed on a database using its in-built intelligence and enhances the performance.
Which of the following Automatic tuning options are used by the Azure SQL database to improve the database performance?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: D
Create Index, Drop Index and FORCE LAST GOOD PLAN are three automatic tuning options available in Azure SQL Managed Instance and Azure SQL Database.
The following table describes these automatic tuning options:
Option A is incorrect.
Create Index, Drop Index, and FORCE LAST GOOD PLAN are three automatic tuning options available in Azure SQL Database.
Option B is incorrect.
Not only Drop Index but Create Index and FORCE LAST GOOD PLAN automatic tuning options are also available in Azure SQL Database.
Option C is incorrect.
Not only FORCE LAST GOOD PLAN but Create Index and Drop Index automatic tuning options are also available in Azure SQL Database.
Option D is correct.
All the given are the automatic tuning options available in Azure SQL Database.
Reference:
To know more about Automatic tuning in the Azure SQL database, please visit the below-given link:
The correct answer is D. All the above.
Azure SQL Database provides Automatic Tuning, which is a feature that can continuously monitor the database's queries and optimize the performance of the database by making changes to the database automatically.
The Automatic Tuning feature in Azure SQL Database has three tuning options to improve database performance, which are as follows:
A. Create Index: This option creates an index on a table if the query optimizer determines that the query's performance can be improved by adding an index. The index can be created automatically in response to a specific query or a set of queries.
B. Drop Index: This option drops an index if the query optimizer determines that the index is not being used or not necessary. Dropping an unused index can improve database performance by reducing the overhead of maintaining the index.
C. FORCE LAST GOOD PLAN: This option enables the database to return to the last known good query execution plan if the query optimizer produces a poor plan. This option helps to ensure that the database continues to perform well, even if there are changes to the database schema or query workload.
In conclusion, the Azure SQL Database provides Automatic Tuning options to improve database performance, which includes creating an index, dropping an index, and forcing the last known good query execution plan.
