Question
Automatic index compaction versus traditional index-maintenance jobs on Azure SQL Managed Instance: what changed?
Answer
Automatic index compaction is GA for Managed Instance with the Always-up-to-date update policy and reduces index space consumption automatically. Traditional maintenance is administrator-scheduled. Use automatic compaction where that update policy is acceptable; retain bespoke maintenance for explicit control.