# Nonclustered Columnstore Indexes
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
devenv-ncci-and-sql-server
devenv-ncci-tuning-and-tracing
devenv-ncci-performance
devenv-migrating-from-sift-to-ncci
devenv-flowfields

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-ncci-overview, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/devenv-ncci-overview/
