Why Cluster Key Used?

1.	Why Cluster Key Used?
Answer» The CLUSTER key is the COLUMN, or group of COLUMNS, that the clustered tables have in common. You specify the columns of the cluster key when CREATING the cluster. You subsequently specify the same columns when creating every table added to the cluster. The cluster key is the column, or group of columns, that the clustered tables have in common. You specify the columns of the cluster key when creating the cluster. You subsequently specify the same columns when creating every table added to the cluster.

Answer»

The CLUSTER key is the COLUMN, or group of COLUMNS, that the clustered tables have in common. You specify the columns of the cluster key when CREATING the cluster. You subsequently specify the same columns when creating every table added to the cluster.

The cluster key is the column, or group of columns, that the clustered tables have in common. You specify the columns of the cluster key when creating the cluster. You subsequently specify the same columns when creating every table added to the cluster.

Discussion

No Comment Found

Related InterviewSolutions

What Is Database Enforced Integrity?
Explain About Oracle Data Blocks?
What Is A Processes?
What Is A Log Writer (lgwr)?
What Is Checkpoint?
What Is System Monitor (smon)?
What Is Pmon?
Explain About The Program Interface?
What Are The Integrity Constraints In Oracle?
Explain About The Security Mechanisms In Oracle 7.3?