sql-serverindexingsql-server-2014indexed-viewcolumnstore

SQL Server columnstore clustered index on an indexed view

I want to have an automatically updated structure in SQL Server that can handle aggregate queries well. Can I create an indexed view in SQL server 2014 that has a columnstore index as its clustered index?

Solution

  • You can't create a columnstore index on a view as per the documentation:

    CREATE COLUMNSTORE INDEX (Transact-SQL)

    In the limitations and restrictions it explicitly states:

    "Cannot be created on a view or indexed view."