SQL Server Error Msg 35305 – The statement failed because a clustered columnstore index cannot be created on a view. Consider creating a nonclustered columnstore index on the view, creating a clustered columnstore index on the base table or creating an index without the COLUMNSTORE keyword on the view.

In this blog post, let’s learn about the error message “35305 – The statement failed because a clustered columnstore index cannot be created on a view. Consider creating a nonclustered columnstore index on the view, creating a clustered columnstore index on the base table or creating an index without the COLUMNSTORE keyword on the view.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

35305 – The statement failed because a clustered columnstore index cannot be created on a view. Consider creating a nonclustered columnstore index on the view, creating a clustered columnstore index on the base table or creating an index without the COLUMNSTORE keyword on the view.

Reason for the Error

To be update soon…

Solution

To be update soon…