Create index on cluster : Cluster « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Cluster
SQL> create cluster user_objects_cluster_btree
  2  ( username varchar2(30) )
  3  size 1024
  4  /

Cluster created.

SQL>
SQL> create index user_objects_idx
  2  on cluster user_objects_cluster_btree
  3  /

Index created.

SQL>
SQL> drop cluster user_objects_cluster_btree;

Cluster dropped.

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