We use two types of execution plan in SQL Server one is Estimated execution plan and another is Actual execution plan.The basic difference is former does not show any output only execution plan of query while later shows both, means you can see output as well as execution plan.But they differ in different situations.
I have tried estimated execution plan for my query see output will come in this way 
See highlighted area we have only two tabs no result.
If I am trying to run Actual estimated plan now we can see there are there tabs in output.
No comments:
Post a Comment