Business Central migrate SIFT to NCCI Technology

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 and do not store…

Continue Reading rs’s Article on their blog

Business Central migrate SIFT to NCCI Technology

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 and do not store aggregated data.

Blog Syndicated with rs’s Permission

Author: Roberto Stefanetti

Share This Post On
Share via
Copy link
Powered by Social Snap