Graphical Execution Plan Icons (SQL Server Management Studio)
Poniższe ikony wyświetlane w SQL Server Management Studio plan wykonania graficzny reprezentują operatory używane przez SQL Server Aby wykonać instrukcje. Aby uzyskać więcej informacji zobaczLogical and Physical Operators Reference.
Podmioty gospodarcze, które są wykonywane równolegle są wyświetlane następujące ikonę równoległym procesie nad operator. .gif "Parallel process icon")
Ikona |
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") |
|
|
Poniższe ikony wyświetlane na plan wykonania graficzny reprezentują Cursor Logical and Physical Showplan Operators używane przez SQL Server Aby wykonać instrukcje.
Ikona |
Operator fizycznej kursor |
|---|---|
.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") |
Poniższe ikony wyświetlane na plan wykonania graficzny reprezentują Parallelism Showplan Operator fizyczne operatory używane przez SQL Server Aby wykonać instrukcje.
Ikona |
Operator fizycznej proste |
|---|---|
.gif "Distribute streams parallelism operator icon") |
|
.gif "Repartition streams parallelism operator icon") |
|
.gif "Gather streams parallelism operator icon") |
Poniższe ikony wyświetlane na plan wykonania graficzny reprezentują Transact-SQL elementy języka używany przez SQL Server.
Ikona |
Element języka |
|---|---|
.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") |