The End of Index Maintenance? | Data Exposed
Automatic index compaction technology is in public preview for Azure SQL.
“fragmentation is as much of an issue anymore.”
Microsoft announced the public preview of automatic index compaction for Azure SQL, addressing challenges with traditional index maintenance. This innovation potentially reduces the need for manual index rebuilding, leveraging advancements in disk technology.