Defining Default Physical Options

Default physical options define physical options for all the objects of a particular type in the model.

  1. Select Database > Default Physical Options to display the Default Physical Options dialog box. There is a tab for each kind of object that supports physical options.

    The Table tab opens by default. The Syntax sub-tab in the left pane lists the physical options available in the DBMS, and the Items sub-tab in the right pane lists the physical options that have been selected for the object.



    The following tools are available for adding and removing physical options to an object:

    Tool

    Action when clicked

    Adds physical option selected in Syntax tab (left pane) to Items tab (right pane)

    Aligns a selected physical option in the Items tab with the corresponding physical option in the Syntax tab

    Removes physical option selected in Items tab

  2. To add a default option for the object, select it in the Syntax pane and click the Add tool to copy it to the Items pane. To add only a sub-parameter for the option, expand the option in the Syntax pane, select the required parameter and then click the Add tool.
  3. To set a default value for a physical option parameter, select it in the Items pane and enter or select the appropriate value in the field below the pane. The entered value will then be displayed against the parameter in the Items list.


  4. Repeat the above steps as many times as necessary to specify all your required physical options. By default, these options will be applied to all tables created subsequently in the model. To apply them to existing tables, click the Apply to button to select the tables to which you want to apply the options, and then click OK.
  5. Select the other tabs to specify physical options for other object types. (Note that the Apply to button is not available on the Database tab).
  6. Click OK to close the Default Physical Options dialog and return to your model.

    The default physical options are stored in your model file. You can view the script for a physical option in the Preview tab of an object for which it is defined.