Can both a table and indexed view be columnstore?

I have a data warehouse fact table with millions of records and it is a clustered columnstore table. I want to have an Indexed View of the table which casts numeric values of a Text column to numbers and text values of the same column to blanks, for faster performance.

If I create the View as a clustered Index View, will the View’s data also be stored in columnstore format?

  • Multi-statement Table Valued Function vs Inline Table Valued Function
  • Log table with millions of rows. Now, what?
  • SQL trigger for updating a table
  • Transpose some columns to row
  • How to get Sql Server XML variable into TEXT column
  • SQL Server 2008 replace multiple word to single word
  • SQL Server columnstore index update/insert in stored procedure
  • SQL SERVER 2012 ColumnStore Index
  • One Solution collect form web for “Can both a table and indexed view be columnstore?”

    Before even reading my answer you should read this excellent post by Niko Neugebauer the dude to go for columnstore indexes in SQL Server.

    To my answer:

    Yes you can create a clustered columnstore index in a view in SQL Server. My recommendation would be to test your view first and then decide if you need a new index or the columnstore index from the underlying table is satisfying your conditions.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.