| Segment |
Specify whether to 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 on ly to tables with variable-length rows.
Valid values are 0, 1, and any value between the minimum and maximum row length
for the table.
|