sql优化常用命令总结时间:2023-03-08 22:48:06 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