<< Click to Display Table of Contents >>

Index Properties

Top Previous Next

This dialog allows you to view or change storage parameters of an index, or to rebuild the index in another tablespace. It shows the following information:

Index name

Table name

Tablespace name (combo box)

% Free, Percentage of free space in a block

Initial and maximum number of transactions

Uniqueness status

Direct load status

Storage of extents in the segment: Initial, next, min extents, max extents, % increase, free lists, freelist groups

Statistics: B-tree level, leaf blocks, distinct keys, average leafs per key, average data per key, clustering factor. Use the Analyze button to analyze the table and to compute, estimate or delete the statistics.

After the OK button is pressed, the operation is performed. The Cancel button closes the dialog without any action.