SQL Server 2005------执行计划和实际计划

Posted on 2009-07-03 10:12 鸡尾虾的壳阅读(539) 评论(0) 收藏举报

显示执行计划的命令：
SET SHOWPLAN_TEXT ON
SET SHOWPLAN_ALL ON
SET SHOWPLAN_XML ON

显示实际计划的命令：
SET STATISTICS PROFILE ON
SET STATISTICS XML ON