Chapter 7. SQL Remote Design for AdaptiveSer verAnywhere
Partitioning tables that do not contain thesubscription expression
Inmany cases, the rows of a table need to be partitioned even when the
subscriptionexpression does not exist in the table.

The Contact example

TheContact database illustrates why and how to partition tables that do not
containthe subscription expression.
Example Hereis a simple database that illustrates the problem.
Contact
contact_key char(10)
name char(40)
cust_key char(12)
Customer
cust_key char(12)
name char(40)
rep_key char(5)
SalesRep
rep_key char(5)
name char(40)
cust_key = cust_key
rep_key =
rep_key
Eachsales representative sells to several customers. At some customers
thereis a single contact, while other customers have several contacts.
Thetables in the
database Thethree tables are described in more detail as follows:
Table Description
SalesRep All sales representativesthat work for the company. The
SalesReptable has the following columns:
♦rep_key An identifier for each sales representative.
Thisis the primary key.
♦name Thename of each sales representative.
TheSQL statement creating this table is as follows:
CREATE TABLE SalesRep (
Rep_key CHAR(12) NOT NULL,
Name CHAR(40) NOT NULL,
PRIMARY KEY (rep_key)
)
105