Nonclustered Columnstore Indexes and Performance
This article looks at the factors you must take into consideration when you deal with nonclustered columnstore indexes (NCCIs) and performance.
Performance factors to consider
The factors that you must take into consideration when you deal with any performance problems that arise include:
- Do you need an NCCI at all (is it being used)?
- Which fields do you need to index?
- Can you disable some or all SIFT indexes and just use an NCCI?
Important
Remember to perform tests every time you make any changes to the NCCI structure. You must ensure that the changes that you have made don't cause problems in any other areas of the application. You must also ensure that your changes don't have a negative effect on performance.
See Also
NCCI Overview)
NCCI and SQL Server
NCCI Tuning and Tracing
Migrating from SIFT to NCCI
FlowFields