Re: IDS Next Version - back on topic

Here's another one: UPDATE STATISTICS DROP DISTRIBUTIONS. No "LOW", just get rid of the distributions. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list

This does take forever when you have to just drop distributions. The following works very well. I have used it prior to inplace upgrades. database <dbname>; delete from sysdistrib where 1=1; Distributions are gone in seconds!!! Use at your own risk!