SIFT – Pardaan.com

Business Central migrate SIFT to NCCI Technology

Understand the Context: Migrating from SumIndexField Technology (SIFT) to Nonclustered Columnstore Indexes (NCCIs) - SIFT keys are maintained when data is inserted, updated, or deleted in a table. However, maintaining these SIFT indexes has performance overhead. - NCCIs, on the other hand, use nonclustered columnstore indexes…

30 July 2024

Dynamics NAV & BC Tips & tricks

CALCSUMS, and SIFT, and Addition! Oh My!

In previous versions of Microsoft Dynamics NAV, if you wanted to add Decimal amounts, you had to either have a SumIndexField defined at the key level so you could use CALCSUM, or you would have to loop through each row and keep a running total. CALCSUMS…

3 September 2015

Dynamics NAV & BC Tips & tricks

NAV2013R2 | Maintain SIFT Index

As I already explained in my last blog post the way performance tuning is done in NAV2013R2 has changed from previous versions. Rather than issueing a SQL Statement for each flowfield in each row on a listpage NAV now uses OUTER APPLY. Bron : Mark Brummel…

23 January 2014