Pro SQL Server 2012 Reporting Services

CHAPTER 2  REPORT AUTHORING: DESIGNING EFFICIENT QUERIES

Figure 2-4. Viewing the query execution output in SSMS

The Execution Plan tab in SSMS shows graphically how the SQL query optimizer chose the most
efficient method for executing the report, based on the different elements of the query. For example, the
query optimizer may have chosen a clustered index instead of a table scan. Each execution step has an
associated cost. Figure 2-5 shows the Execution Plan tab for this query.