Tuning T-SQL - Professional SQL Server 2005 Performance Tuning - page 247

Table 9-2: Query Plan Operators (continued)

Operator Operator

Icon Icon

Remote Update Switch

RID Lookup Table Delete

Row Count Spool Table Insert

Segment Table Scan

Sequence Table Spool

SequenceProject Table Update

Sort Table-valued Function

Split Top

Spool UDX

Stream Aggregate Update (Database Engine)

Table 9-3 shows the various types of cursor operators.

Table 9-4 shows the various parallelism operators.

Table 9-5 shows the various T-SQL operators.

Table 9-6 provides detailed information about the operators shown in the previous tables. Each operator
above will have specific information associated with it, although not all operators contain all the items
listed. Furthermore, you can see this information by simply hovering the mouse cursor over the operator.