Re: Help - Clustered Index to Keep the Table in Desired Order

diana, > How long would a re-clustering take (We are at dev. phase and no > production experience with Informix) given that also, set your pdqpriority to 100 when you do this, it will be much faster! and if you are doing it during the evening, then you don't have to worry about it impacting other users. a big job will steal system resouces at pdq 100, and this will affect the performance of the system, so nightime is the rightime! mickm