CODEWITHSUNDEEP
sqlsql-serverviewindexed
Uli
Uli

Reputation: 11

Create indexed view that contains text columns

I require to create an indexed view in SQL Server. Two tables are inner joined in this view. Both tables also contain text columns. The view index is created on an index column of table1.

CREATE UNIQUE CLUSTERED INDEX IX_COL1 ON dbo.View1(TABLE1_PK);

Error: The index can not be created as the tables also contain text fields.

As those text fields can not be dropped from the view - is there any known workaround that allows indexing of a view an still include text fields columns?

Upvotes: 0

Views: 189

Answers (0)

Related Questions