From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation
Join today to access over 24,700 courses taught by industry experts.
Automatic index tuning
From the course: Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation
Automatic index tuning
- [Instructor] Azure SQL database includes a feature called automatic index tuning, and it can assist administrators in maintaining performing queries. You can enable them from the Azure portal, either click on the SQL database resource, here on the dashboard, or to show you an alternate method, go to the menu, click on SQL databases, and then you'll find the Azure SQL database listed there. From the overview page of the resource, you can scroll down until you get to the intelligent performance section and then click automatic tuning. Here you'll find three options that you can turn on, off, or inherit the status from the databases defaults. You can see that force plan is currently set on and create and drop index defaults to off. So what do each of these options do? Force plan is a little bit of a misleading name in my opinion. Inside of the database, this feature is called force last good plan or automatic plan correction, and both of those terms give a better idea about what this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.