How can I see the execution plan for stored procedures and triggers in SQL Server?
如何在SQL Server中查看存储过程和触发器的执行计划?
3 个解决方案
#1
Yes, you can using SQL Profiler. See Using SQL Server Profiler
是的,您可以使用SQL事件探查器。请参阅使用SQL Server Profiler
#2
you can do
你可以做
set showplan_text on
or hit CTRL + K and it will be included as a separate tab next to query results
或点击CTRL + K,它将作为单独的选项卡包含在查询结果旁边
#1
Yes, you can using SQL Profiler. See Using SQL Server Profiler
是的,您可以使用SQL事件探查器。请参阅使用SQL Server Profiler
#2
you can do
你可以做
set showplan_text on
or hit CTRL + K and it will be included as a separate tab next to query results
或点击CTRL + K,它将作为单独的选项卡包含在查询结果旁边
#3
Assuming you're using MSSQL, yes, see here
假设你正在使用MSSQL,是的,请看这里