摘要:
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 @ 阅读全文