Online Documentation for SQL Manager for Oracle

Clustered


A iconObjects_Table_Clustered Clustered table is the table that is part of a cluster. The table columns correspond to the cluster columns. Generally, the cluster columns of a table are the column or columns that make up its primary key or a portion of its primary key.

 

Table properties - Clustered

 

The following type-specific properties can be set for Clustered tables:

 

To create a clustered table, you need to specify name of the cluster and its schema.

 

Cluster owner

Use the drop-down list to select schema to contain the cluster.

 

Cluster name

Use the drop-down list to select name of the cluster for the clustered table.

 

 

Use the area below to specify one column from the table for each column in the cluster key.