ms-sql的索引视图的问题,欢迎大家讨论
---------------------------------------------------
set ANSI_NULLS on
go
set ANSI_PADDING on
go
set ANSI_WARNINGS on
go
set ARITHABORT on
go
set CONCAT_NULL_YIELDS_NULL on
go
set QUOTED_IDENTIFIER on
go
set NUMERIC_ROUNDABORT OFF
go
drop table index_view_table;
create table index_view_table(
a varchar(8) not null primary key,
b decimal(10,2) not null)
go
insert into index_view_table(a,b) values('1',1);
insert into index_view_table(a,b) values('2',1);
insert into index_view_table(a,b) values('3',2);
insert into index_view_table(a,b) values('4',2);
go
drop view V_1
go
CREATE VIEW V_1 WITH SCHEMABINDING
AS
SELECT b,
count_big(1) as ZongJiaoYi
FROM dbo.index_view_table
group by b
go
CREATE UNIQUE CLUSTERED INDEX in_V_1 ON V_1 (b)
go
--1.通过查询分析器看,并没有索引in_V_1
SELECT b,
count_big(1) as ZongJiaoYi
FROM dbo.index_view_table
group by b
--2.通过查询分析器看,没有使用索引in_V_1
select * from V_1
--为什么呢,是我数据库版本的问题吗mssql2000,标准安装,四个服务全部启动了,我是以sa登录的,在master数据库下,在新建的数据库下也一样有问题?