Clusters

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

Clusters provide an optional method of storing table data. A cluster comprises of a group of tables that share the same data blocks, and which are grouped together because they share common columns and are often used together. The related columns of tables stored in a cluster are known as the cluster key.

There are two types of clusters:

  • Index
  • Hash

Index clusters store the cluster data together and index the cluster key, which should make them faster at retrieving a range of data rows.

Hash clusters apply hashing functions to the cluster key to determine the physical location of a data row, which should make them faster at retrieving specific data rows.

Note: To place a table on a cluster, 6 include the ON CLUSTER syntax within the CREATE TABLE statement. Placing a table on a cluster precludes you from placing it on a tablespace or defining the associated storage parameters.

Creating and editing

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

ORCL

Allocate Extent

Analyze

Deallocate Unused Space

Drop

Extract

Migrate

Report

Truncate