黑夜的狼

摘要： 创建视图索引首先要把视图绑定到架构alter view view_prod_ProductProgress WITH SCHEMABINDING asSELECT * from dbo.T1 as a inner join dbo.T2 as b on a.id=b.id绑定到架构时,使用表要由两部分构成,就是 dbo.T1接下来创建索引if (exists (select * from sys.indexes where name = 'idx_prod_ProductProgress_Sht')) drop index view_prod_ProductProgress.i 阅读全文