- **Description**: Broadcast operations distribute data from one node to all other nodes in a distributed database system. This is often used in join operations where a small table is sent to all nodes to join with a larger, distributed table. - **Performance**: Can be network-intensive, especially with large datasets. - **Factors**: Size of the dataset being broadcast, network bandwidth, number of nodes. - **Cost**: `network_transfer_cost * size_of_data * number_of_nodes` - ![[ex_broadcast_motion.svg|200]] - **Operates on**: [[Result Set]] - **Workloads**: - [[IPC]] - [[MessageQueueSend]] - [[MessageQueueReceive]] - [[LWLock]] - [[ParallelQueryDSA]]