<< Click to Display Table of Contents >>

Clusters

Top Previous Next

The upper list displays clusters stored in the current tablespace:

Cluster Name

Owner

Key size, i.e. estimated size of cluster key plus associated rows

Cluster type

Number of hash keys, if a hash cluster

Hash expression

The following context operations are available:

 

Drop ...

Drops the selected cluster(s).

 

Truncate ...

Truncates the cluster, i.e. deletes all rows.

 

Properties/Alter ...

Shows a modal dialog for viewing and modifying cluster properties.

 

Allocate Extent...

Allocates a new extent to the cluster.

 

Grid View

For more information, see object window

Clicking on the plus sign to the left of the cluster name displays the tables associated with the cluster:

Table name

Comments

The context toolbar and the right mouse button popup menu allow the following operation:

 

Grid View

For more information, see object window