In Business Central Cloud (currently version 26), performance issues can arise due to index fragmentation in SQL-based tables. While on-premises environments allow manual index maintenance via SQL Server tools, cloud environments lack native mechanisms for index optimization.
I propose introducing a built-in automated procedure within Business Central Cloud that:
- Periodically analyzes index fragmentation across tenant tables.
- Automatically rebuilds or reorganizes indexes based on configurable thresholds.
- Provides logging and telemetry for tracking optimization events.
- Offers scheduling options via the Job Queue or Admin Center.
This feature would enhance performance, reduce support overhead, and align with cloud-native best practices for database health and maintenance.
Comments
automatically rebuilding of indexes will help us a lot. we have severe issues about damaged indexes in ILE table after installing a new version.
Category: Development
