Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Related information
NCCI and SQL Server
NCCI Tuning and Tracing
NCCI Performance
Migrating from SIFT to NCCI
FlowFields