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

Table 9-3: Cursor Operators

Cursor Physical Operator Cursor Physical Operator

Icon Icon

Cursor Catchall Population Query

Dynamic Refresh Query

Fetch Query Snapshot

Keyset

Table 9-4: Parallelism Operators

Parallelism Physical
Operator

Parallelism Physical
Operator

Icon Icon

Distribute Streams Gather Streams

Repartition Streams

Table 9-5: T-SQL Operators

Language Element Language Element

Icon Icon

Assign Intrinsic

Convert (Database Engine) Language Element Catchall

Declare Result

If While