Re: Update Statistics Guidelines

Run Arts DoStats Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. ________________________________ From: malcolm.iiug [mailto:maliiug@btopenworld.com] Posted At: 13 March 2007 11:10 Posted To: comp.databases.informix Conversation: Update Statistics Guidelines Subject: Update Statistics Guidelines I am looking to redefine an UPDATE STATISTICS strategy for one of my customers. Currently they use a scatter gun approach and perform UPDATE STATISTICS HIGH on some tables every night, for other table theyrun UPDATE STATISTICS MEDIUM. On a weekly basis they run UPDATE STATISTICS HIGH and MEDIUM on a different selection of tables. I do know that the weekly script does UPDATE STATISTICS HIGH on a table that the daily script does UPDATE STATISTICS MEDIUM for. Today they encountered some locking problems on sysfragments while running UPDATE STATS but they also had a program that went "ape" and had problems all over the place so that was probably the cause. What is the collective wisdom of this gathering on when and why to run UPDATE STATISTICS with IDS 10? Regards Malcolm