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






Create cluster and set hashkeys, size

   
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>

   
    
    
  








Related examples in the same category

1.create cluster
2.Cluster with varchar2 column
3.Create cluster and then create table on top of it
4.Exclusive aggregation using the clustering technique
5.Existence-dependent aggregation using the clustering technique
6.Oracle provides a clustering technique that can be very useful for an aggregation relationship.
7.drop cluster