Oninit cdi / Archive
Talk to an expert →

Auto Update Statistics

Posted in 2014

Topics: Platform-Specific Issues

LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Informix 11.50.FC8 - solaris environment After reading the documentation, it appears that AUS is scheduled to run over the weekend, by default, and all "UPDATE STATISTICS" commands that do not have time to execute are saved. My question is, "How configurable is AUS?". I would like to schedule it more often. In running it more often, I also assume that it will just not update statistics if nothing has changed appreciatively on a table. I would also like to adjust the times that it runs. Thank you. Larry

↪ replying to LARRY SORENSEN
LLOYD SERRAO — — source: IIUG Forums & Mailing Lists

Larry, Refer the below presentation for more information on AUS http://presentations.oninit.com/public/2009IIUG/D14_Chakraborty_Automatic_Update _Statistics.pdf If you have OAT installed its much easier to tune update stats. Hope it helps. Lloyd

↪ replying to LLOYD SERRAO
LARRY SORENSEN — — source: IIUG Forums & Mailing Lists

Thank you for the added information. > To: ids@iiug.org > From: serrao.lloyd@gmail.com > Subject: Re: Auto Update Statistics [33425] > Date: Wed, 23 Jul 2014 21:47:33 -0400 > > Larry, > > Refer the below presentation for more information on AUS > > > http://presentations.oninit.com/public/2009IIUG/D14_Chakraborty_Automatic_Update _Statistics.pdf > > If you have OAT installed its much easier to tune update stats. > Hope it helps. > > Lloyd > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Related threads

Glossary