Indexes are fundamental to database performance, but too often, they’re treated as “set it and forget it” structures. As the data landscape evolves—with hybrid cloud deployments, real-time analytics, ...

For example, sys.indexes show column store indexes as type = 6 and type_desc as ‘NONCLUSTERED COLUMNSTORE.’ There also are two new system tables, sys.column_store_segments and ...