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.
|