Query Window Execution Plan Pane

SQL Query Analyzer Help

SQL Query Analyzer Help

Query Window Execution Plan Pane

The Execution Plan options graphically display the data retrieval methods chosen by the Microsoft® SQL Server™ query optimizer.

The Execution Plan pane uses icons to represent the execution of specific statements and queries in SQL Server rather than the tabular representation produced by the SET SHOWPLAN_ALL or SET SHOWPLAN_TEXT statements.

Icons

Graphically Displaying the Execution Plan Using SQL Server Query Analyzer

Physical operators

Assert

Bookmark Lookup

Clustered Index Delete

Clustered Index Insert

Clustered Index Scan

Clustered Index Seek

Clustered Index Update

Collapse

Compute Scalar

Concatenation

Constant Scan

Deleted Scan

Filter (clsColumn)

Hash Match

Hash Match Root

Hash Match Team

Index Delete

Index Insert

Index Scan

Index Seek

Index Spool

Index Update

Inserted Scan

Log Row Scan

Merge Join

Nested Loops

Parallelism

Parameter Table Scan

Remote Delete

Remote Insert

Remote Query

Remote Scan

Remote Update

Row Count Spool

Sequence

Sort

Stream Aggregate

Table Delete

Table Insert

Table Scan

Table Spool

Table Update

Top

Cursor physical operator

Dynamic

Fetch Query

Keyset

Population Query

Refresh Query

Snapshot