Setting Physical Options

Set physical options for each table as needed for your RAPCache or RAPStore database.

  1. Right-click the table and choose Properties.
  2. Define any options needed.
    • (RAPCache only) In the Physical Options (Common) tab, choose from the physical options most commonly set for the object.
    • In the Physical Options tab, choose from all available options.
    • (RAPCache only) In the Partitions tab, set partitioning options for selected columns.

    For example, for the RAPCache, choose partitioning options.

    For more information on partitioning and other physical options useful for RAP data stores, see Installation and Configuration Guide, Performance and Tuning, and the Adaptive Server Enterprise and Sybase IQ documentation sets.

Related tasks
Generating a RAPCache or RAPStore Model from a RAP Messages Model
Checking Indexes
Adding Foreign Keys
Setting Datatypes for Lookup Columns