Columnstore Indexes and Computed Columns in SQL Server 2016
Category:
query-performance
You can’t do everything with a columnstore index – but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect.