sql优化常用命令总结

1.显示执行计划的详细步骤

  SET SHOWPLAN_ALL ON;

  SET SHOWPLAN_ALL OFF;

2. 显示执行语句的IO成本，时间成本

  SET STATISTICS IO ON

  SET STATISTICS IO OFF

 SET STATISTICS TIME ON

 SET STATISTICS TIME OFF

posted @ 2018-04-25 15:17  桃花雪  阅读(390)  评论(0)  编辑  收藏  举报