We are looking into turing on Automatic tuning in Azure SQL Database (https://docs.microsoft.com/en-gb/azure/azure-sql/database/automatic-tuning-overview?view=azuresql) and use all 3 available options. Does the create index option reorganise or rebuild the index from time to time? I can't find any documentation on how the index that is created is maintained. Can someone please point me to such documentation?
1 Answers
Automatic Tuning on Azure SQL Database does not do maintenance of indexes and statistics. Here a Microsoft Engineer states that in most scenarios is not needed, but in the same forum thread I shared my experience step-by-step with images on how you can schedule a database maintenance on Azure SQL.
Related