SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Database Engine

Accessing and Changing Database Data

Query Performance

Query Tuning

Analyzing a Query

Logical and Physical Operators Reference

Aggregate Showplan Operator

Arithmetic Expression Showplan Operator

Assert Showplan Operator

Assign Showplan Operator

Async Concat Showplan Operator

Bitmap Showplan Operator

Bitmap Create Showplan Operator

Bookmark Lookup Showplan Operator

Branch Repartition Showplan Operator

Broadcast Showplan Operator

Cache Showplan Operator

Clustered Index Delete Showplan Operator

Clustered Index Insert Showplan Operator

Clustered Index Scan Showplan Operator

Clustered Index Seek Showplan Operator

Clustered Index Update Showplan Operator

Collapse Showplan Operator

Compute Scalar Showplan Operator

Concatenation Showplan Operator

Constant Scan Showplan Operator

Convert Showplan Operator

Cross Join Showplan Operator

Cursor Catchall Showplan Operator

Declare Showplan Operator

Delete Showplan Operator

Deleted Scan Showplan Operator

Distinct Showplan Operator

Distinct Sort Showplan Operator

Distribute Streams Showplan Operator

Dynamic Showplan Operator

Eager Spool Showplan Operator

Fetch Query Showplan Operator

Filter Showplan Operator

Flow Distinct Showplan Operator

Full Outer Join Showplan Operator

Gather Streams Showplan Operator

Hash Match Showplan Operator

Hash Match Root Showplan Operator

Hash Match Team Showplan Operator

If Showplan Operator

Inner Join Showplan Operator

Insert Showplan Operator

Inserted Scan Showplan Operator

Intrinsic Showplan Operator

Iterator Catchall Showplan Operator

Key Lookup Showplan Operator

Keyset Showplan Operator

Language Element Catchall Showplan Operator

Lazy Spool Showplan Operator

Left Anti Semi Join Showplan Operator

Left Outer Join Showplan Operator

Left Semi Join Showplan Operator

Log Row Scan Showplan Operator

Merge Interval Showplan Operator

Merge Join Showplan Operator

Nested Loops Showplan Operator

Nonclustered Index Delete Showplan Operator

Nonclustered Index Insert Showplan Operator

Nonclustered Index Scan Showplan Operator

Nonclustered Index Seek Showplan Operator

Nonclustered Index Spool Showplan Operator

Nonclustered Index Update Showplan Operator

Online Index Insert Showplan Operator

Parallelism Showplan Operator

Parameter Table Scan Showplan Operator

Partial Aggregate Showplan Operator

Population Query Showplan Operator

Refresh Query Showplan Operator

Remote Delete Showplan Operator

Remote Insert Showplan Operator

Remote Query Showplan Operator

Remote Scan Showplan Operator

Remote Update Showplan Operator

Repartition Streams Showplan Operator

Result Showplan Operator

RID Lookup Showplan Operator

Right Anti Semi Join Showplan Operator

Right Outer Join Showplan Operator

Right Semi Join Showplan Operator

Row Count Spool Showplan Operator

Segment Showplan Operator

Segment Repartition Showplan Operator

Sequence Showplan Operator

Sequence Project Showplan Operator

Snapshot Showplan Operator

Sort Showplan Operator

Split Showplan Operator

Spool Showplan Operator

Stream Aggregate Showplan Operator

Switch Showplan Operator

Table Delete Showplan Operator

Table Insert Showplan Operator

Table Scan Showplan Operator

Table Spool Showplan Operator

Table Update Showplan Operator

Table-valued Function Showplan Operator

Top Showplan Operator

Top N Sort Showplan Operator

UDX Showplan Operator

Union Showplan Operator

Update Showplan Operator

While Showplan Operator

Cursor Logical and Physical Showplan Operators

Minimize

This topic has not yet been rated - Rate this topic

Broadcast Showplan Operator

SQL Server 2005

Broadcast has one child node and n parent nodes. Broadcast sends its input rows to multiple consumers on demand. Each consumer gets all of the rows. For example, if all of the consumers are build sides of a hash join, then n copies of the hash tables will be built.

Tasks

How to: Display an Actual Execution Plan

Reference

Distribute Streams Showplan Operator

Concepts

Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.