Update Statistics

If the AUS evaluator is run and says x number of tables need stats updated, then AUS runs and no-one touches the database, shouldn't the number that the evaluator says are needed decrease? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6 "Don't document the problem, fix it." - Atli Björgvin Oddsson

If you look at this inside OAT it might be a little easier to see. OAT breaks this number up into two parts Small tables If a table is under the size of AUS_SMALL_TABLES (default 100) then all of these tables are consider expired. This is because changes to the size of these tables effect queries so much and to run update stats on these tables is so fast Large tables Over the size of AUS_SMALL_TABLES only expire when one of the other policies are met (AUS_CHANGE or AUS_AGE). John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 08/10/2010 02:48:33 PM: > [image removed] > > Update Statistics [20827]> > Wyza, Jonathon > > to: > > ids > > 08/10/2010 02:50 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > If the AUS evaluator is run and says x number of tables need stats updated, > then AUS runs and no-one touches the database, shouldn't the number t= hat the > evaluator says are needed decrease? > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.ed= u> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Bj=F6rgvin Oddsson > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

Only once the evaluator has run again. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 10, 2010 at 5:48 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > If the AUS evaluator is run and says x number of tables need stats updated, > then AUS runs and no-one touches the database, shouldn't the number that > the > evaluator says are needed decrease? > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e0cb4e887ca1107bba048d7ffb65