Remove Automatic Primary Key Inclusion in Secondary Indexes to Improve Performance and Reduce Storage Costs
Problem Statement
Business Central currently automatically includes all primary key fields in every secondary index, a design inherited from Navision. While this made sense in the original Navision database engine, it creates significant problems on modern SQL Server implementations:
STATUS DETAILS
New