Index Properties

• Name – specify a different index name.
• Unique – prohibits duplicate index values.
• Clustered – physical order of rows on the current database device to be the same as the indexed order of the rows.
• Suspect – indicates the integrity of the index is suspect.
• Using cache – specifies the current cache binding.
• Bind to – change the cache binding.

Displays the columns used in the index.

• Segment – change the segment on which the index is placed.
• Duplicate keys – indicates if duplicate keys are allowed.
• Duplicate rows – indicates if duplicate rows are allowed.
• Data presorted – indicates the index data has been presorted.
• Cache strategy – you can specify the Adaptive Server strategy for determining where in cache to place data pages when reading in new data. You can also choose to prefetch index pages by performing large I/Os of up to eight data pages simultaneously.
• Rows per page – limits the number of rows on data pages and the leaf-level pages of indexes.
• Reserve page gap – specifies a ratio of filled pages to empty pages to be left during extent I/O allocation operations.
• Fill factor – specifies how full Adaptive Server makes each page when it creates a new index on existing data.

Displays the name, segment, and creation date.