Re: Creating clusters after tables created

From: Neil Greene <deepthought!neil_at_ms.uky.edu>
Date: Wed, 13 May 1992 18:52:22 GMT
Message-ID: <1992May13.185222.4548_at_deepthought.uucp>


In article <1992May12.182331.2434_at_deepthought.uucp> Neil Greene <deepthought!neil_at_ms.uky.edu> writes:
> I have created several tables which should be clustered using the cluster
> clause in the create table statement. Several million rows of data has now
> been loaded into these tables. Is there any problem in creating the clusters
> since the tables and data has already been created/loaded using an alter
> statement?
>
> --
> Neil Greene
> ARCI, Inc.
> Kentucky NeXT User Group, Inc.
> Phone: 606.254.4060

Since I cannot find any reference to any alter cluster clause allowing one to modify tables, I have recreated and reread all data into the tables. During the recreation I properly clustered and indexed my tables.

-- 
Neil Greene
ARCI, Inc.
Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Received on Wed May 13 1992 - 20:52:22 CEST

Original text of this message