1

We are looking into turing on Automatic tuning in Azure SQL Database (https://learn.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?

user1329339
  • 1,295
  • 1
  • 11
  • 26

1 Answers1

0

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.

ChrisGPT was on strike
  • 127,765
  • 105
  • 273
  • 257
Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30