Replicate vs Broadcast

What is the difference between replicate and broadcast ?

Questions by annegrace1   answers by annegrace1

Showing Answers 1 - 2 of 2 Answers


  • Sep 7th, 2009

Replication moves data to a specified target, usually at a specified time, and usually is usually defined by the ETL team or DBA. Broadcast moves data to targets in the system as needed, and is usually done by the dbms itself. 

Broadcasting usually refers to partitioned databases copying data from one partition to another in order to service a join requested by a query.

e.g. You may set up replication to copy a small lookup table to all partitions in order to avoid the dbms broadcasting it to every partition as needed. This remove the overhead of moving the data needed for common joins from the query execution time.

  Was this answer useful?  Yes


  • Sep 21st, 2011

replicate supports the component parallelism and broadcast supports data parallelism i.e fan-out,all-to-all.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions