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 |
|---|---|
.gif "Arithmetic expression operator icon")
|
|
.gif "Assert operator icon")
|
|
.gif "Bitmap operator icon")
|
|
.gif "Bookmark lookup operator icon")
|
|
.gif "Clustered index delete operator icon")
|
|
.gif "Clustered index insert operator icon")
|
|
.gif "Clustered index scan operator icon")
|
|
.gif "Clustered index seek operator icon")
|
|
.gif "Clustered index update operator icon")
|
|
.gif "Collapse operator icon")
|
|
.gif "Compute scalar operator icon")
|
|
.gif "Concatenation operator icon")
|
|
.gif "Constant scan operator icon")
|
|
.gif "Delete (Database Engine) operator icon")
|
|
.gif "Delete scan operator icon")
|
|
.gif "Spool operator icon")
|
|
.gif "Filter (Database Engine) operator icon")
|
|
.gif "Hash match operator icon")
|
|
.gif "Hash match root operator icon")
|
|
.gif "Hash match team operator icon")
|
|
.gif "Insert (Database Engine) operator icon")
|
|
.gif "Inserted scan operator icon")
|
|
.gif "Iterator catchall operator icon")
|
|
|
|
|
.gif "Log row scan operator icon")
|
|
.gif "Merge interval operator icon")
|
|
.gif "Merge join operator icon")
|
|
.gif "Nested loops operator icon")
|
|
.gif "Nonclustered index delete operator icon")
|
|
.gif "Nonclustered index insert operator icon")
|
|
.gif "Nonclustered index scan operator icon")
|
|
.gif "Nonclustered index seek operator icon")
|
|
.gif "Nonclustered index spool operator icon")
|
|
.gif "Nonclustered index update operator icon")
|
|
.gif "Online index insert operator icon")
|
|
.gif "Parameter table scan operator icon")
|
|
.gif "Remote delete operator icon")
|
|
.gif "Remote insert operator icon")
|
|
.gif "Remote query operator icon")
|
|
.gif "Remote scan operator icon")
|
|
.gif "Remote update operator icon")
|
|
.gif "RID lookup operator icon")
|
|
.gif "Row count spool operator icon")
|
|
.gif "Segment operator icon")
|
|
.gif "Sequence operator icon")
|
|
.gif "Sequence project operator icon")
|
|
.gif "Sort operator icon")
|
|
.gif "Split operator icon")
|
|
|
|
|
.gif "Stream aggregate operator icon")
|
|
.gif "Switch operator icon")
|
|
.gif "Table delete operator icon")
|
|
.gif "Table insert operator icon")
|
|
.gif "Table scan operator icon")
|
|
.gif "Table spool operator icon")
|
|
.gif "Table update operator icon")
|
|
.gif "Table-valued function operator icon")
|
|
.gif "Top operator icon")
|
|
.gif "Extended operator (UDX) icon")
|
|
|
|
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 |
|---|---|
.gif "Cursor catchall cursor operator icon")
|
|
.gif "Dynamic cursor operator icon")
|
|
.gif "Fetch query cursor operator icon")
|
|
.gif "Keyset cursor operator icon")
|
|
.gif "Population query cursor operator icon")
|
|
.gif "Refresh query cursor operator icon")
|
|
.gif "Snapshot cursor operator icon")
|
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 |
|---|---|
.gif "Distribute streams parallelism operator icon")
|
|
.gif "Repartition streams parallelism operator icon")
|
|
.gif "Gather streams parallelism operator icon")
|
The following icons displayed in the graphical execution plan represent the Transact-SQL language elements used by SQL Server.
| Icon | Language element |
|---|---|
.gif "Assign language element icon")
|
|
.gif "Convert (Database Engine) language element icon")
|
|
.gif "Declare language element icon")
|
|
.gif "If language element icon")
|
|
.gif "Intrinsic language element icon")
|
|
.gif "Language element catchall icon")
|
|
.gif "Result language element icon")
|
|
.gif "While language element icon")
|
See Also
Reference
Displaying Graphical Execution Plans (SQL Server Management Studio)