cccc And execution plan is a technique to determine how to access data and
complete the query , then represent it in a graphical format of statistics and
process tree.
There are many ways to execute query, SQL server choose the best beneficial way to reduce time and to improve performance of the query .
The query plan describe the detail method data used by query optimizer. That way and SQL server developer can see the query execution plan and estimated time for the query.That help SQL server developer to assist query optimization because the execute query plan of stored in procedure cache,and if similar execution is done , the execution plan is retrieve and reuse.
Below is the example of how query estimation can can be seen
1)Open an SQL server management Studio and select new query window.
2)Write your query on the new query window.
3)From Menu , select display estimated execution plan
you will see the execution plan will be displayed as below
SQL Server Execution plan are two type
Actual Execution plan (Ctrl+M) : It is created after the execution of query, display the steps that was performed during the execution.
Estimated Execution plan (Ctrl+L): It is created without a executing the query , approximate execution plan is shown.
There are many ways to execute query, SQL server choose the best beneficial way to reduce time and to improve performance of the query .
The query plan describe the detail method data used by query optimizer. That way and SQL server developer can see the query execution plan and estimated time for the query.That help SQL server developer to assist query optimization because the execute query plan of stored in procedure cache,and if similar execution is done , the execution plan is retrieve and reuse.
Below is the example of how query estimation can can be seen
1)Open an SQL server management Studio and select new query window.
2)Write your query on the new query window.
3)From Menu , select display estimated execution plan
you will see the execution plan will be displayed as below
SQL Server Execution plan are two type
Actual Execution plan (Ctrl+M) : It is created after the execution of query, display the steps that was performed during the execution.
Estimated Execution plan (Ctrl+L): It is created without a executing the query , approximate execution plan is shown.
No comments:
Post a Comment