Re: Cluster Index

Posted in 1997

Stefan — Tue, 24 Jun 1997 02:58:57 -0100 — source: Informix-list mailing list archive (1991-1998)

Priti Jhaveri wrote: > Hi, if you create a clustured index, there is no need to do anything with the other indexes. Informix will re-create the table itself. But sometimes it's a good idea to drop an index and create the index again. Bye Stefan > Hi, > > 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. > > Thank you very much for your input. > > Regards, > Priti > >