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