27,579
社区成员
发帖
与我相关
我的任务
分享
select * from ..... a.creadate >= '2009-10-1 00:00:00' and a.creadate <= '2009-11-18 23:59:59'
--496条,30秒
select * from ..... a.creadate >= '2009-1-1 00:00:00' and a.creadate<= '2009-11-18 23:59:59'
--20735,2秒
--清空缓存
CHECKPOINT
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
select getdate()
select * from ..... a.creadate >= '2009-10-1 00:00:00' and a.creadate <= '2009-11-18 23:59:59'
select getdate()
CHECKPOINT
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
select getdate()
select * from ..... a.creadate >= '2009-1-1 00:00:00' and a.creadate<= '2009-11-18 23:59:59'
select getdate()