Create cluster and set hashkeys, size : Cluster « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Cluster
SQL>
SQL>
SQL> create cluster user_objects_cluster_hash
  2  ( username varchar2(30) )
  3  hashkeys 100
  4  size 3168
  5  /

Cluster created.

SQL>
SQL> drop cluster user_objects_cluster_hash;

Cluster dropped.

SQL>
SQL>








6.24.Cluster
6.24.1.Create cluster and set hashkeys, size
6.24.2.Create cluster and then create table on top of it
6.24.3.Cluster with varchar2 column
6.24.4.drop cluster
6.24.5.Existence-dependent aggregation using the clustering technique
6.24.6.Exclusive aggregation using the clustering technique
6.24.7.Create index on cluster