SqlServer分析sql语句执行效率
--分析sql执行效率
set statistics time on;--打开时间统计
set statistics profile on
--需要分析的sql
select * from ...
set statistics io off
set statistics time off
set statistics profile off
“fool me once,shame on you. fool me twice, shame on me.”,翻译过来的意思是“愚弄我一次,是你坏;愚弄我两次,是我蠢”。