1, 删除缓存:
checkpoint
sql 语句
dbcc dropcleanbuffers
2,显示执行计划
set showplan_text on;
slq 语句
set showplan_text off;
1, 删除缓存:
checkpoint
sql 语句
dbcc dropcleanbuffers
2,显示执行计划
set showplan_text on;
slq 语句
set showplan_text off;
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/05/20/1740118.html