8. Using Advanced Features : Lookup Tables : How You Set Up Horizontal Partitioning
 
Share this page                  
How You Set Up Horizontal Partitioning
A horizontally partitioned table uses a base CDDS, which contains the whole replicated base table, and partitioned CDDSs that each contain only those rows that are associated with the particular value assigned to that CDDS in the lookup table.
To set up horizontal partitioning, you must complete two main tasks:
Create and populate the lookup table in every participating database.
Implement horizontal partitioning through Visual DBA or the Replicator Manager.