Posted inDynamics NAV & BC Tips & tricks
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…