Sybase DC38133-01-0902-01 To handle this case, using an example, Contain the subscription column

Chapter 8. SQL Remote Design for Adaptive Server Enterprise

Partitioning tables that do not contain the subscription column

	In many cases, the rows of a table need to be partitioned even when the
	subscription column does not exist in the table. This section describes how
	to handle this case, using an example.
The Contact example
	The Contact database illustrates why and how to partition tables that do not
	contain the subscription column.
Example	Here is a simple database that illustrates the problem. We call this database
	the Contact database, because it contains a Contact table in addition to the
	two tables described earlier in this chapter.
	Contact
	contact_key	char(10)
	name	char(40)
	cust_key	char(12)

cust_key = cust_key

Customer

cust_key char(12)

namechar(40)

rep_key char(5)

rep_key =

rep_key

SalesRep

rep_key char(5)

name char(40)

	Each sales representative sells to several customers. At some customers
	there is a single contact, while other customers have several contacts.
The tables in the	The three tables are described in more detail as follows:
database

149