Editing and Viewing Table Storage Properties

Use the Storage page in the Table Schema Editor to edit and view storage properties for SQL Anywhere, Adaptive Server Enterprise, or Sybase IQ tables.

Prerequisites 

Make sure you are connected to a SQL Anywhere, an Adaptive Server Enterprise, or a Sybase IQ database.

  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Expand the Tables folder and find the appropriate table.
  3. Right-click the table and select Edit to open Table Schema Editor.
  4. Select the Storage page.

    If you opened an ASE table, you can view and edit the following properties:

    Field Description
    Segment Create the index on a default or system segment.
    Max Row Per Page Specify the maximum rows of data allowed on each data page. Valid values are 0 – 255. The default is 0.
    Reserve Page Gap Specify the ratio of filled pages to empty pages left during extent I/O allocation operations. For each specified num_pages, an empty page is left for future expansion of the table. Valid values are 0 – 255.
    Identity Gap Specify a value to override the system identity gap for this table.
    Fill Factor Specify the value that determines how full Adaptive Server makes each index page when it is creating a new index of existing data.
    Replacement Strategy Specify the replacement strategy to fetch and discard buffers in cache for table scans and index scans for I/O of any size.
    Prefetch Strategy Set the prefetch strategy for data pages of a table or on the leaf-level pages of a nonclustered index.
    Locking Schema Specify the locking schema to be used for the table:
    • All Pages
    • Data Rows
    • Data Pages
    Expected Row Size Specify the expected row size and applies only to data rows and data pages locking schemes, and only to tables with variable-length rows. Valid values are 0, 1, and any value between the minimum and maximum row length for the table.

    If you opened a SQL Anywhere or Sybase IQ table, you can view and edit the following properties:

    Field Description
    DBSpace Name Identifies the dbspace used to store the table (view-only).
    DBSpace File Identifies the file where the dbspace is located (view-only).
    Free Size Reserved for Each Table Page Specify the percentage of free space you want to reserve for each table page. The free space is used if rows increase in size when data is updated. If there is no free space in a table page, every increase in the size of a row on that page requires the row to be split across multiple table pages, causing row fragmentation and possible performance degradation.
    Note: If the Sybase IQ table is stored in IQ_SYSTEM.MAIN, it does not have free space properties.
  5. Edit the storage properties and select File > Save.
  6. Verify your changes and click Save.

    You can also click Save As to save the changes to a project folder.

  7. Review the status in SQL Results view.
Related tasks
Editing Table Schema Data
Creating a Table

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com