Shulou(Shulou.com)05/31 Report--

How to get the execution plan in SQLSERVER, aiming at this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

There are two ways to get the plan executed:

1. One is to turn on some switches in front of the instruction to let the execution plan information be typed in the result set, which is more suitable for tuning a single statement in a test environment. The most commonly used of these switches is the copy code as follows: SET SHOWPLAN_ALL ON SET SHOWPLAN_ALL ON-(does reuse have an execution plan and does SQSERVERL feel that it lacks an index). You can only see SET STATISTICS PROFILE ON in the output of XML.

And if you use SSMS, you can use the shortcut key: Ctrl+L lowercase L he will execute your statement and display the execution plan, but will not return the result set 2, another way is to use event tracking in SQL Trace to track the execution plan of the statement. Common events are: SHOWPLAN ALL, SHOWPLAN STATISTICS PROFILE, SHOWPLAN XML STATISTICS PROFILE this method has the advantage of not turning on any switch, can be used to directly track the application's statement execution. The disadvantage is that he will catch all the sentences. If SQLSERVER is busy, the output can be large and may affect performance, so be careful-most of the information collected by these two methods is the same. The XML approach returns the result as a XML structure, and in SQL Trace, the result can graphically display the execution plan and its related information. This output may be friendly to statements that are relatively simple to execute the plan. However, for complex execution plans, if displayed graphically, it is difficult to fit all of the screen, and the statistical information of each step will not be displayed until the mouse is clicked. I think it is not as readable as the text output format.

This is the answer to the question about how to get the execution plan in SQLSERVER. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.