Clustering
From: P S Narayan <pnarayan_at_cs.tamu.edu>
Date: 26 Jan 1994 18:00:19 GMT
Message-ID: <2i6b3j$6k1_at_news.tamu.edu>
Date: 26 Jan 1994 18:00:19 GMT
Message-ID: <2i6b3j$6k1_at_news.tamu.edu>
Hello,
In Oracle (any version that you are aware of), suppose I cluster two relations
based on a cluster key. That is, the cluster key is a single column common to
both the relations.
As far as the users are concerned, this clustering is transparent to them and
they access the tables as any other non-clustered table.
Is there something called a CLUSTER_INDEX built on the cluster_key? What does
it mean? How different is it from a normal index? Is it necessary to have
this cluster_index?
Thanks for replies
Narayan
pnarayan_at_cs.tamu.edu
Received on Wed Jan 26 1994 - 19:00:19 CET