create table s
(
id int identity(1,1),
name varchar(10)
)
select * from s where id>1500
insert into s values('asd')
declare @s varchar(2000)
declare @n varchar(2000)
set @n='n'
declare @a int
set @a=0
while (@a<500)
begin
select @a+=1
select @s=@n+CONVERT(varchar(2000),@a)
insert into s values(@s)
end
create clustered index index_id on
s (id) with fillfactor=50
create nonclustered index ix_name on s (name)
select * from s where name='n151'
select * from s where id>1500
|