The first operator is the Clustered Index Scan that reads data from the.If we read the execution plan from right to left, we’ll note the following: table for orders with a unit price greater than 1,000. Suppose you execute the following query in an sample database and view the actual execution plan. It helps you follow the logical data flow in the query. You begin with the top right-most execution plan operator and move towards the left.
Generally, we read execution plans from right to left. Reading a graphical SQL Server execution plan
Now, we’ll explore things you need to know when evaluating SQL Server execution plans and how to best interpret the information. In a past article, SQL Server Execution Plan - What is it and How Does it Help with Performance Problems? we explored the high-level query execution workflow, the different types of execution plans (graphical, XML and text), along with actual and estimated execution plans. They reveal query processing and involved phases such as affected tables, indexes, statistics, types of joins, the number of affected rows, query processing, data sort and data retrieval. SQL Server execution plans are a gateway for query optimizer and query executions for database professionals.