Index Properties

Use the Index Properties window to modify cache bindings, specify a device segment, and change index values.

Click the Name field of the index, then click the drop-down arrow and select Properties.

Pages Properties
General
  • 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.
  • Index compression – specify whether to apply index compression.
Columns

Displays the columns used in the index.

Miscellaneous
  • 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 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 each page is made when a new index is created on existing data.
Index Partitions

Displays the name, segment, and creation date.

Related reference
Trigger Properties
Foreign Key Properties
Check Constraint Properties
Partition Properties
Table Properties
Column Properties