Broadcast Showplan Operator

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.

See Also


How to: Display an Actual Execution Plan


Distribute Streams Showplan Operator


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

Help and Information

Getting SQL Server 2005 Assistance