Dynamics 365 Business Central: Development - Developers can define indexes that span fields from a base table and its table extensions

🚨 The Signal: Developers can now define database indexes spanning base tables and their extensions in Dynamics 365 Business Central. This change impacts data integrity, query performance, and potentially data access controls within customisations.

The Impact

Developers and security architects are affected, with a risk of misconfigured data access or performance issues if indexes are not properly designed.

• Developers: New capabilities require understanding to prevent performance degradation.
• Security Architects: Review customisations for potential data exposure via new indexing.
• Database Administrators: Monitor performance and integrity of new cross-table indexes.
• Compliance Teams: Assess if new data structures impact data handling compliance.

The Action

1. Review Dynamics 365 Business Central development guidelines for best practices on cross-table indexing.
2. Conduct security architecture reviews for customisations utilising this new indexing capability.
3. Implement robust testing protocols for all new or modified indexes to ensure data integrity and performance.
4. Update internal documentation for data governance and security policies to reflect new data model capabilities.

Domain: Other · Impact: medium · Workload: Other