Create an index on a SQL Anywhere table to speed access to data rows by pointing SQL Anywhere to the location of table data on disk.
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. |
Virtual | Make the index virtual, which simulates the existence of an index without actually building a full index. |
Dbspace | Specify the type of dbspace in which to place the index. The default is SYSTEM. |
Comments | Enter comments for the index. |