Chapter 3 Building Physical Diagrams

Defining physical options for individual objects

You can set physical options for selected objects to override the default physical options (see "Defining default physical options").

Choosing between the different physical option tabs

There are two different interfaces for specifying physical options for individual objects, both of which are accessible through tabs on the object's property sheet:

• Physical Options (Common) – this tab is displayed by default (along with the Partition tab, if applicable), and lists the most commonly-used physical options in the format of a standard property sheet tab.
• Physical Options (All) – this tab is hidden by default, and lists all the available physical options for the object in a tree format. To display this tab, click the Property Sheet Menu button and select Customize Favorite Tabs→Physical Options (All).

You can change physical options on either of the tabs and these changes will also be reflected on the other.

Tablespace and storage options

You can choose a tablespace or storage already defined in the model as a value for a tablespace or storage that you define for a table. These are listed in a dropdown listbox below the right pane in the Options page.

For more information on defining tablespaces and storages, see the Generating a Database from a PDM chapter.

To define physical options via the Physical Options (Common) tab:

1. Double-click the object to open its property sheet, and click the Physical Options (Common) tab or the Partition tab.
2. Enter values for the necessary option parameters and click OK.

To define physical options via the Physical Options (All) tab:

1. Double-click the object to open its property sheet, and click the Physical Options (All) tab. If this tab is not visible, then click the Property Sheet Menu button and select Customize Favorite Tabs→Physical Options (All).
2. Follow the procedure giving in "Defining default physical options" to modify the appropriate options.

Copyright (C) 2005. Sybase Inc. All rights reserved.