摘要: 1.只有关联条件有非聚集索引--清空缓存DBCC FREEPROCCACHE WITH NO_INFOMSGSDBCC FREESESSIONCACHE WITH NO_INFOMSGSDBCC FREESYSTEMCACHE('All') WITH NO_INFOMSGSDBCC DROPCLEANBUFFERS WITH NO_INFOMSGSSET NOCOUNT onCREATE TABLE #result(状态 varchar(20),[id(毫秒)] INT,[guid(毫秒)] INT)DECLARE @start INTDECLARE @end INTSET @ 阅读全文
posted @ 2012-05-30 11:49 qanholas 阅读(930) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示