Cluster with varchar2 column : Cluster « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Cluster
SQL>
SQL>
SQL> create cluster lookup_hash_cluster(
  2      key_col varchar2(30)
  3  )
  4  single table
  5  hashkeys 20000
  6  size 255
  7  /

Cluster created.

SQL>
SQL> drop cluster lookup_hash_cluster;

Cluster dropped.








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