日期:2014-05-17 浏览次数:20524 次
drop table t1
create table T1
(
id int identity(1,1),
Name varchar(50),
Remark varchar(200)
)
insert into T1 values (NEWID(),NEWID())
go 100000
drop index index_1 on t1
create unique clustered index index_1 on t1(id)
dbcc dropcleanbuffers
set statistics io on
set statistics profile on
select top 10 * from T1 where id >(select MAX(id) from T1 where id<10*101)
--无论有没有在ID键上建立聚集索引,当前查询都不会载入非当前页面的数据,我这里仅仅是个例子,楼主可以再测测看