Re: Cluster Index

From the SQL manual:

CLUSTER specifies that the table is to be part of the cluster. The columns listed in this clause are the table columns that correspond to the cluster’s columns. Generally, the cluster columns of a table are the column or columns that comprise its primary key or a portion of its primary key.
Specify one column from the table for each column in the cluster key. The columns are matched by position, not by name.

Paulo Jorge Silv wrote:
>
> My doubt is simple . I'd like to Know that if it's possible to have two
> distinct tables joined by to common keys in a cluster index, but with the
> particularity that those names are different. example : CLIENT's table
> (CL_RADIX) and STATISTICS table (ST_RADIX)
>
> S-TECNO - Portugal
> PJS
Received on Mon Apr 06 1998 - 00:00:00 CDT