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 aggregated data. All analytical queries are done at runtime.
Source : Roberto Stefanetti Business Central Blog
Read more…