Create an index on an Adaptive Server Enterprise table to speed access to data rows by pointing Adaptive Server Enterprise to the location of table data on disk.
Before you can create an index, be sure the data server is running, and you created and established a connection to it.
Use Load Default to load defaults for this tab. Save settings to default with Save As Default.
Field | Description |
---|---|
Unique | Make the index unique. A unique index permits no two rows to have the same index value, including NULL. |
Clustered | Make the index clustered. In clustered indexes, table data is physically stored in the order of the keys on the index. |
Ignore Duplicate Key | If you have chosen to make the index unique, specify whether or not to ignore duplicate keys. The default is No. |
Duplicate Row | If you have chosen to make the index clustered but not unique, specify how duplicate rows are to be treated. You can allow, disallow, or ignore duplicate rows. The default is to not allow duplicate rows. |
Segment | Specify whether to create the index on a default or system segment. |
Fill Factor | Choose the fill factor setting, which specifies how full Adaptive Server Enterprise makes each page when it creates a new index on existing data. The default is 1. |
Rows Per Page | Specify the number of rows on data pages and the leaf-level pages of indexes. The default is 0. |
Reserve Page Gap | Specify the ratio of filled pages to empty pages to be left during I/O allocation operations. For each specified number of pages, an empty page is left for future expansion of the index. Valid values are 0 – 255. The default is 0. |