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

Table 9-2: Query Plan Operators (continued)

Operator Operator

Icon Icon

Deleted Scan Inserted Scan

Eager Spool Iterator Catchall

Filter (Database Engine) Lazy Spool

Hash Match Log Row Scan

Hash Match Root (SQL
Server 2000 Only)

Merge Interval

Hash Match Team (SQL
Server 2000 Only)

Merge Join

Nonclustered Index Delete Nested Loops

Nonclustered Index Insert Online Index Insert

Nonclustered Index Scan Parameter Table Scan

Nonclustered Index Seek Remote Delete

Nonclustered Index Spool Remote Insert

Nonclustered Index Update Remote Query

Insert (Database Engine) Remote Scan