What are clusters?
Clusters are groups of one or more tables physically stored together because they share common columns and are often used together. This improves disk access time. The related columns of the tables in a cluster are called the cluster key. The cluster key is indexed so that rows of the cluster can be retrieved with a minimum amount of I/O. No matter how many tables within the cluster contain the cluster key value, it is stored only once each in the cluster and the cluster index. Therefore, less storage is required. Whether or not a table is part of a cluster is transparent to users and to applications. Data stored in a clustered table is accessed by SQL in the same way as data stored in a nonclustered table.
‘Clusters’ organize your search results into groups based on the most frequent words in the top 200 results. For example, a search on “PubMed” might return a cluster of documents that contain the phrase “Working with Search Results”. Clustering helps you narrow down a large set of results quickly to find what you’re looking for. If there is a plus sign () next to a cluster, click on it to view smaller clusters. If there is a vertical line separating two or more clusters, they have the same number of matches for each term. For example, the earlier search on “PubMed” might return a cluster labeled: Genome | Structure (11). Click ‘remix’ to see additional clusters.
