
Chapter 10 Denormalizing a PDM
Managing horizontal partitions
You can manage partitions from the Partitions page of the property sheet of a horizontal partitioning object. The following actions can be performed:
- Open the property sheets of the tables corresponding to the partitions. You can modify the properties of the table from the property sheet. If you modify the name or the code of the table, the name or code of the corresponding partition is automatically updated
- Add more partitions and define the properties of their corresponding tables
- Use the Comment column to comment and specify the discriminating criteria of the different partitions
- Delete one or several partitions and their corresponding tables. When you delete a partition, a message box is displayed to ask you if you want to delete the corresponding table. You can delete a partition and keep the corresponding table, however you cannot delete a table and keep an orphan partition
You cannot move or paste a horizontal partitioning object into another model or package.
Copyright (C) 2006. Sybase Inc. All rights reserved.
|
|