--可以为每一个字段,创建索引视图
CREATE VIEW V_T1_c1 WITH SCHEMABINDINGASSELECT c1, COUNT_BIG(*)AS cnt FROM dbo.T1 GROUP BY c1GOCREATE UNIQUE CLUSTERED INDEXidx_uc_c1 ON V_T1_c1(c1)
CREATE VIEW V_T1_c1 WITH SCHEMABINDINGASSELECT c1, COUNT_BIG(*)AS cnt FROM dbo.T1 GROUP BY c1GOCREATE UNIQUE CLUSTERED INDEXidx_uc_c1 ON V_T1_c1(c1)
我要在这个视图的基础上,建一个关于pinpai_name的索引,我该怎么做啊???
create view vshangpin
as
select a.shangpin_id,a.shangpin_name,a.shangpin_tiaoxingma,b.leibie_name,
c.pinpai_name,d.danwei_name,e.jlfs_name,f.shangpin_num,f.shangpin_jinjia,
f.shangpin_shoujia
from shangpin_table a,leibie_table b,pinpai_table c,danwei_table d,jiliangfangshi_table e,
cangkuxiangqing_table f
where a.leibie_id = b.leibie_id and a.pinpai_id = c.pinpai_id and a.danwei_id = d.danwei_id
and a.jlfs_id = e.jlfs_id and a.shangpin_id = f.shangpin_id
go
我要在这个视图的基础上,建一个关于pinpai_name的索引,我该怎么做啊???
create view vshangpin
as
select a.shangpin_id,a.shangpin_name,a.shangpin_tiaoxingma,b.leibie_name,
c.pinpai_name,d.danwei_name,e.jlfs_name,f.shangpin_num,f.shangpin_jinjia,
f.shangpin_shoujia
from shangpin_table a,leibie_table b,pinpai_table c,danwei_table d,
jiliangfangshi_table e,cangkuxiangqing_table f
where a.leibie_id = b.leibie_id and a.pinpai_id = c.pinpai_id
and a.danwei_id = d.danwei_id and a.jlfs_id = e.jlfs_id
and a.shangpin_id = f.shangpin_id
go
create view vshangpin WITH SCHEMABINDING
as
select a.shangpin_id,a.shangpin_name,a.shangpin_tiaoxingma,b.leibie_name,
c.pinpai_name,d.danwei_name,e.jlfs_name,f.shangpin_num,f.shangpin_jinjia,
f.shangpin_shoujia
from shangpin_table a,leibie_table b,pinpai_table c,danwei_table d,
jiliangfangshi_table e,cangkuxiangqing_table f
where a.leibie_id = b.leibie_id and a.pinpai_id = c.pinpai_id
and a.danwei_id = d.danwei_id and a.jlfs_id = e.jlfs_id
and a.shangpin_id = f.shangpin_id
go
CREATE UNIQUE CLUSTERED INDEXidx_uc_pinpai_name ON vshangpin (pinpai_name)
服务器: 消息 4512,级别 16,状态 3,过程 vshangpin,行 3
无法将 视图 'vshangpin' 绑定到架构,因为名称 'shangpin_table' 对于架构绑定无效。名称必须由两部分构成,并且对象不能引用自身。