Applies to Product - Dynamics 365 Business Central
What’s happening?
Customers are experiencing issues with large index sizes in their Business Central SaaS environments. Specifically, they report that despite deleting rows from custom tables, the index sizes continue to grow, leading to concerns about database space and performance.
Reason:
The underlying cause of the index size growth may be related to the way indexing and defragmentation are handled in the system. In some cases, the expected reindexing or defragmentation does not occur automatically after data deletions, resulting in persistent large index sizes.
Resolution:
- For cases where the index size is large and needs to be reduced, it is recommended to modify Business Central retention policies to save less information. This can help manage the overall database size.
- Review the Database Missing Indexes feature in Business Central to identify potential indexing improvements that can enhance performance. More information can be found in the official documentation regarding missing indexes.
- If the issue persists and cannot be resolved through the above methods, it may be necessary to escalate the case to the database team for further investigation.