Cluster Index

Posted in 1997

Priti Jhaveri — 23 Jun 1997 15:38:15 -0400 — source: Informix-list mailing list archive (1991-1998)

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