Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Cluster Editor

Use the cluster editor to join tables that are closely related for storing on the same area of the disk. This lets you interleave the rows of two or more tables together into a single area called a cluster.

About Cluster Objects

The cluster key is the column or columns by which the tables are usually joined in a query. You can only cluster together tables that you own.

You can create either an index cluster or a hash cluster. With an indexed table or index cluster, Oracle locates the rows in a table using key values that Oracle stores in a separate index. To use hashing, you create a hash cluster and load tables into it. Oracle physically stores the rows of a table in a hash cluster and retrieves them according to the results of a hash function.

The characteristics and usage of this database object are described in the Oracle documentation.


Ways to Open The Cluster Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Cluster Editor

Open the Cluster Editor.

From DB Navigator or Find objects Dialog

Right click on a Cluster object and click Open.

Open the selected Cluster object in the Cluster Editor.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating