Filter
Top Products
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)
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
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
database
The three tables are described in more detail as follows:
149