Columnstore-Indexes

Tag: columnstore-indexes

Filtered Indexes: Rowstore vs Nonclustered Columnstore

By Kendra Little on November 10, 2016

Category: indexing

Tags: filtered-indexes , columnstore-indexes

SQL Server has two types of filtered indexes:

The “classic” filtered nonclustered rowstore index, introduced in SQL Server 2008, available in all editions
The newfangled filtered nonclustered columnstore index, introduced in SQL Server 2016, available in Enterprise Edition

Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.