SumIndexfields
are a special feature of Dynamics NAV that give it the power to calculate FlowFields
on a large scale. It is a decimal field that can be assigned in the Key section, as shown in the following screenshot:
SumIndexfields
has always been a part of Dynamics NAV, which gives it a unique capability that, if calculated with a normal approach, is generally inefficient.
As has been said, too much sugar leads to diabetes. Similarly, excessive use of keys or SIFT
fields can negatively affect the system's performance. The two main performance issues are:
The index maintenance processing load
The table locking interference
The table locking interference occurs when multiple threads request update access to a set of records that affect the SIFT
values.
On the other hand, lack of necessary keys or SIFT
definitions can also cause severe performance issues.