Edit

Share via

Nonclustered Columnstore Indexes

  • Article

Nonclustered columnstore indexes (NCCIs) let you quickly calculate the sums of numeric data type (Decimal, Integer, BigInteger, and Duration) columns in tables. Calculations can be done in tables with millions of records. NCCIs optimize the performance of FlowFields and query results in a Business Central application. The articles in this section describe how NCCIs are implemented in Business Central.

NCCI and SQL Server
NCCI Tuning and Tracing
NCCI Performance
Migrating from SIFT to NCCI
FlowFields