Graphical Execution Plan Icons (SQL Server Management Studio)


http://msdn.microsoft.com/en-us/library/ms175913(SQL.90).aspx

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
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: