Create cluster and then create table on top of it : Cluster « Table « Oracle PL/SQL Tutorial





SQL> create table myTable(
  2    key_col  primary key,
  3    key_val
  4  )as
  5  select object_name, max( owner||'_'||object_id )from all_objects group by object_name
  6  /

Table created.

SQL>
SQL>
SQL> create cluster myTableHash(
  2      key_col varchar2(30)
  3  )
  4  single table
  5  hashkeys 20000
  6  size 255
  7  /

Cluster created.

SQL>
SQL>
SQL> create table lookup_hash(
  2     key_col,
  3     key_val )
  4  cluster myTableHash(key_col)
  5  as
  6  select * from myTable;

Table created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL> drop table lookup_hash;

Table dropped.

SQL> drop cluster myTableHash;

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