Re: Cluster Index

>Informix-DSA version 7.11UC2. >This is about the cluster index. If I have a table table_1 with 5 indexes: > > idx1 Unique on col1 >idx2 composite on colx+coly > idx3 duplicate on colz >idx4 composite on col1+col2 >idx5 on some colw >all NON CLUSTER. > >Considering that I have enough space. >Ques: If I try to alter one index, say idx1 to CLUSTER, whether it will try to >rebuild other 4 indexes or not. >If yes, then How does it work? Like first create the Cluster index and then >other 4 indexes or some other way. > The process is to first rebuild the data table - ordered by the data items of the index to be clustered. Since the data is reorganized, the rowids are no longer what they were before, so all indexes have to be rebuilt. Thank you very much for your input. Regards, Priti Madison Pruet