Understanding SIFT
SIFT stands for Sum Index Field Technology; it keeps track of data of type decimal and helps to complete complex calculations quickly. Let's see how it works.
How to do it...
Design
Table 379 Detailed Cust. Ledg. Entry-keys.Click on View | Keys from the menu.
The selected key has a value in the
SumIndexFieldscolumn. Go to Properties of the selected keys. The property,MaintainSIFTIndex, tells the SQL Server to store the total ofSumIndexFields.
How it works...
Initially, SIFT values were stored in actual tables. Later, it was identified that inserting multiple entries in the SIFT table on every transaction puts an extra load on the system performance. To reduce this load from NAV 5 SP1, these values are stored in View and called VSIFT. In this example, we will focus on VSIFT.
Let's take a look at the fourth key Customer No., Initial Entry Due Date, Posting Date, Currency Code. In the NAV key, the count starts at zero; that's why we said the fourth key. The VSIFT view name...
