create cluster : Cluster « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Cluster

create 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>








Related examples in the same category

1.Cluster with varchar2 column
2.Create cluster and set hashkeys, size
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