17
SumIndex Fields does not have a purpose on a unique keys as for each primary key additional View on SQL Server is created with the same content in the view as in the table. This has a negative influences on the performance as the view has to be maintaned and there is no benefit from this view. My suggestion is to remove SumIndex fields from all primary keys in the application.

Example is in Table 37 Sales Line but in general all tables with a lot of data are affected.
Category: General
STATUS DETAILS
Under Review
Ideas Administrator

Thank you for your feedback. We are considering adding it to our roadmap.

Your help is greatly appreciated,
Business Central Team

Comments

M

Fully agree

Category: General

M

I agree totally. Some big performance issue can be solved by removing the sumindexfields of the primary key.

Category: General