Sample Header Ad - 728x90

Are online index REBUILD operation possible on every Azure SQL database?

0 votes
0 answers
1085 views
I am trying to find informations about the possibility to operate online index REORGANIZE/REBUILD on a database. What I actually found in the Microsoft documentation is that: > Reorganizing an index uses minimal system resources and is an online operation. > Depending on the type of index and database engine version, a rebuild operation can be done online or offline. The documentation is also indicating that: > Online index operations are not available in every SQL Server edition. For more information, see Editions and supported features of SQL Server. If I follow the link giving more details about the differences between the multiple SQL Server editions, it says that "Online index create and rebuild" is only supported by "Enterprise Editions". But now I would like to have more information about the possibility to operate online index REBUILD on Azure SQL database and I cannot find any explicit documentation page about it. - Is there any limitation on Azure SQL databases too? - Or online index REBUILD is possible for any Azure SQL database? Does someone have some documentation link to share or anymore information about this specific point?
Asked by Alexandre D. (101 rep)
Apr 2, 2020, 12:31 PM
Last activity: Apr 2, 2020, 01:24 PM