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.

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	Expand the Databases folder. Expand the tree for a database and then the tree for the appropriate schema owner.
   From a SQL Anywhere or Sybase IQ connection profile	Expand the tree for a database. 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.