sqlserver 索引视图 对 版本有 要求,体验版没这功能,开发,企业版倒是可以用。
如果是体验版,建议你用表结构吧!
CREATE VIEW V_Remark WITH SCHEMABINDING AS SELECT [ID],COUNT_BIG(*) as Qum FROM [dbo].[StrText] GROUP BY IDGOCREATE UNIQUE CLUSTERED INDEX V_Remark_UCI_ID ON V_Remark ([ID])
视图没有索引