SQL Operations
SQL Server: Operations
http://msdn.microsoft.com/en-us/library/ms175913.aspx
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
| |
Dynamic
| |
Fetch Query
| |
Keyset
| |
Population Query
| |
Refresh Query
| |
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
| |
Repartition Streams
| |
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
| |
Convert
| |
Declare
| |
If
| |
Intrinsic
| |
Language Element Catchall
| |
Result
| |
While |