Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

Group property sheet: Permissions tab Next Page

Index property sheet: General tab

The General tab of the Index property sheet has the following components:

Name    Shows the name of the index. You can edit the name of the index in this field.

Type    Shows the type of object. The object type can be foreign key index, primary key index, unique constraint index, or index.

Unique    Shows whether values in the index must be unique. The unique value is set when you create a new index.

Table    Shows the name and owner of the table with which the index is associated. This only appears if the index is on a table.

Materialized view    Shows the name and owner of the materialized view with which the index is associated. This only appears if the index is on a materialized view.

Dbspace    Shows the database file, or dbspace, where the index is located. This only applies to indexes on base tables and materialized views.

Clustered    Shows whether this index is a clustered index. Clustered indexes are supported for SQL Anywhere databases that are version 8.0.2 and higher.

Clustered indexes in SQL Anywhere store the table rows in approximately the same order as they appear in the corresponding index. Using a clustered index can lead to performance benefits by reducing the number of times each page needs to be read into memory. Only one index on a table can be a clustered index.

For more information about clustered indexes, see CREATE INDEX statement.

Index type    Shows the store type of index the table has. The possible values are compressed B-tree or hash B-tree.

Comment    Provides a place for you to type a text description of the index. For example, you could use this area to describe the index's purpose in the system.

See also