AW: drop distributions

Posted in 2008

Habichtsberg, Reinhard — Wed, 2 Apr 2008 08:49:37 +0200 — source: Usenet: comp.databases.informix

> -----Ursprüngliche Nachricht----- > Von: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]Im Auftrag von Fernando Nunes > Gesendet am: Mittwoch, 19. März 2008 00:27 > An: informix-list@iiug.org > Betreff: Re: drop distributions > > ... > > If you can afford the testing, do "UPDATE STATISTICS FOR > TABLE tabname(xpto) > DROP DISTRIBUTIONS" > where "xpto" is a column that *doesn't* belong to any index... > Regards. > > -- > Fernando Nunes > Portugal > ... Did as you suggested but the distributions for the table remained in sysdistrib. Could it be that only distributions for the specified column would be dropped? Regards, Reinhard.

↪ replying to Habichtsberg, Reinhard

Fernando Nunes — Wed, 02 Apr 2008 23:06:38 +0100 — source: Usenet: comp.databases.informix

Habichtsberg, Reinhard wrote: > >> -----Urspr'ngliche Nachricht----- >> Von: informix-list-bounces@iiug.org >> [mailto:informix-list-bounces@iiug.org]Im Auftrag von Fernando Nunes >> Gesendet am: Mittwoch, 19. M'rz 2008 00:27 >> An: informix-list@iiug.org >> Betreff: Re: drop distributions >> >> ... >> >> If you can afford the testing, do "UPDATE STATISTICS FOR >> TABLE tabname(xpto) >> DROP DISTRIBUTIONS" >> where "xpto" is a column that *doesn't* belong to any index... >> Regards. >> >> -- >> Fernando Nunes >> Portugal >> ... > > Did as you suggested but the distributions for the table remained in > sysdistrib. Could it be that only distributions for the specified column > would be dropped? > > Regards, > Reinhard. Yes... I should not be posting at night... sorry... -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

Glossary

UPDATE STATISTICS