Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2005
Query Performance
Query Tuning
Analyzing a Query
 Graphical Execution Plan Icons (SQL...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
Graphical Execution Plan Icons (SQL Server Management Studio)

The following icons displayed in the SQL Server Management Studio graphical execution plan represent operators used by SQL Server to execute statements. For more information, see Logical and Physical Operators Reference.

Icon Operator
Arithmetic expression operator icon

Arithmetic Expression

Assert operator icon

Assert

Bitmap operator icon

Bitmap

Bookmark lookup operator icon

Bookmark Lookup

Clustered index delete operator icon

Clustered Index Delete

Clustered index insert operator icon

Clustered Index Insert

Clustered index scan operator icon

Clustered Index Scan

Clustered index seek operator icon

Clustered Index Seek

Clustered index update operator icon

Clustered Index Update

Collapse operator icon

Collapse

Compute scalar operator icon

Compute Scalar

Concatenation operator icon

Concatenation

Constant scan operator icon

Constant Scan

Delete (Database Engine) operator icon

Delete

Delete scan operator icon

Deleted Scan

Spool operator icon

Eager Spool

Filter (Database Engine) operator icon

Filter

Hash match operator icon

Hash Match

Hash match root operator icon

Hash Match Root

Hash match team operator icon

Hash Match Team

Insert (Database Engine) operator icon

Insert

Inserted scan operator icon

Inserted Scan

Iterator catchall operator icon

Iterator Catchall

Spool operator icon

Lazy Spool

Log row scan operator icon

Log Row Scan

Merge interval operator icon

Merge Interval

Merge join operator icon

Merge Join

Nested loops operator icon

Nested Loops

Nonclustered index delete operator icon

Nonclustered Index Delete

Nonclustered index insert operator icon

Nonclustered Index Insert

Nonclustered index scan operator icon

Nonclustered Index Scan

Nonclustered index seek operator icon

Nonclustered Index Seek

Nonclustered index spool operator icon

Nonclustered Index Spool

Nonclustered index update operator icon

Nonclustered Index Update

Online index insert operator icon

Online Index Insert

Parameter table scan operator icon

Parameter Table Scan

Remote delete operator icon

Remote Delete

Remote insert operator icon

Remote Insert

Remote query operator icon

Remote Query

Remote scan operator icon

Remote Scan

Remote update operator icon

Remote Update

RID lookup operator icon

RID Lookup

Row count spool operator icon

Row Count Spool

Segment operator icon

Segment

Sequence operator icon

Sequence

Sequence project operator icon

SequenceProject

Sort operator icon

Sort

Split operator icon

Split

Spool operator icon

Spool

Stream aggregate operator icon

Stream Aggregate

Switch operator icon

Switch

Table delete operator icon

Table Delete

Table insert operator icon

Table Insert

Table scan operator icon

Table Scan

Table spool operator icon

Table Spool

Table update operator icon

Table Update

Table-valued function operator icon

Table-valued Function

Top operator icon

Top

Extended operator (UDX) icon

UDX

Update (Database Engine) operator icon

Update

The following icons displayed in the graphical execution plan represent the Cursor Logical and Physical Showplan Operators used by SQL Server to execute statements.

Icon Cursor physical operator
Cursor catchall cursor operator icon

Cursor Catchall

Dynamic cursor operator icon

Dynamic

Fetch query cursor operator icon

Fetch Query

Keyset cursor operator icon

Keyset

Population query cursor operator icon

Population Query

Refresh query cursor operator icon

Refresh Query

Snapshot cursor operator icon

Snapshot

The following icons displayed in the graphical execution plan represent the Parallelism Showplan Operator physical operators used by SQL Server to execute statements.

Icon Parallelism physical operator
Distribute streams parallelism operator icon

Distribute Streams

Repartition streams parallelism operator icon

Repartition Streams

Gather streams parallelism operator icon

Gather Streams

The following icons displayed in the graphical execution plan represent the Transact-SQL language elements used by SQL Server.

Icon Language element
Assign language element icon

Assign

Convert (Database Engine) language element icon

Convert

Declare language element icon

Declare

If language element icon

If

Intrinsic language element icon

Intrinsic

Language element catchall icon

Language Element Catchall

Result language element icon

Result

While language element icon

While

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker