Oninit cdi / Archive
Talk to an expert →

Re: update statistics high

Posted in 2000

Topics: Platform-Specific Issues, Versions, Editions & End-of-Life

Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)

From: him_lommel@t-online.de (Andreas Lommel) >I have IDS 7.3 on solaris 2.6. When I use update statistics high this >job takes a long time. What can I do ? Wait? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown
Mr.B — — source: Informix-list mailing list archive (1991-1998)

run update statistics medium Obnoxio The Clown wrote: > From: him_lommel@t-online.de (Andreas Lommel) > > >I have IDS 7.3 on solaris 2.6. When I use update statistics high this > >job takes a long time. What can I do ? > > Wait? > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown
mars1972@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Don't do high on the entire database. medium on database, high on specific colulmns. You can also thread it when you do it on specific columns. In article <8bfge5$7ap$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: him_lommel@t-online.de (Andreas Lommel) > > >I have IDS 7.3 on solaris 2.6. When I use update statistics high this > >job takes a long time. What can I do ? > > Wait? > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary