locks

> > > > > > Cluster indexes are best on static tables. I have a clustered index in my > > zipcode table (cause we very rarely change that table). Clustering will > > improve your queries and deletes shouldn't affect the clustering (unless > > they are followed by adds). Updates may affect the clustering but only > > if the columns that makeup the clustered index are changed. > > Just in case anyone from Informix is listening, this brings up a flaw, > or at least hole in the technology. Clustering should not have to be > redone because of general table maintainace type stuff. There *are* > databases out their that retain the cluster index on non-static tables. > > I can imagine its tricky, but it sure would be nice. We are working > with tables that have hundreds of thousands of rows, and its not very > feasible to take the system down for long prcedures like this (hence > our need for *Online*. > > > > > > > -- > Naomi Walker (aka N7FSA) Anasazi Inc. Phoenix, Arizona > naomi%anasaz.UUCP@asuvax.eas.asu.edu > > Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook) > -- Naomi Walker (aka N7FSA) Anasazi Inc. Phoenix, Arizona naomi%anasaz.UUCP@asuvax.eas.asu.edu Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook)