34,838
社区成员




/**************Script 2************************************/
use tempdb
go
if exists (select * from dbo.sysobjects where id = object_id(N'[tbl1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [tbl1]
GO
create table tbl1
(学生号 int,学生姓名 varchar(20),性别 char(2), 年龄 int,入学时间 datetime,备注 char(500))
go
declare @i int
set @i=0
declare @j int
set @j=0
while @i<5000
begin
if (rand()*10>3) set @j=1 else set @j=0
insert into tbl1 values(@i,
char( rand()*10+100)+char( rand()*5+50)+char( rand()*3+100)+char( rand()*6+80),
@j, 20+rand()*10,convert(varchar(20), getdate()-rand()*3000,112),
char( rand()*9+100)+char( rand()*4+50)+char( rand()*2+130)+char( rand()*5+70))
set @i=@i+1
end
/**************************************************/
create nonclustered index idx_学生姓名 on tbl1(学生姓名)
/******Script 5***********************************/
set statistics profile on
set statistics io on
go
select 学生姓名 from tbl1 where 学生姓名 in ('d2dP','d2dQ')
go
set statistics profile off
set statistics io off
/*************************************************/
rows executes stmttext
18 1 select 学生姓名 from tbl1 where 学生姓名 in ('d2dP','d2dQ')
18 1 |--Index Seek(OBJECT:([tempdb].[dbo].[tbl1].[idx_学生姓名]), SEEK:([tempdb].[dbo].[tbl1].[学生姓名]='d2dP' OR [tempdb].[dbo].[tbl1].[学生姓名]='d2dQ') ORDERED FORWARD)