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. |
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center