Re: Way to determine UPDATE STATISTICS

Posted in 1998

Eric_Melillo@agsea.com — Thu, 17 Dec 1998 06:14:40 -0800 — source: Informix-list mailing list archive (1991-1998)

Get Art Kagels' utilities (from the iiug web site) -- dostats does a good job of constructing all of the recommended update statistics for all tables. I am aware of only one scenario that it doesn't handle well -- If you have a column that heads and index and that same column heads another index in descending order ( that's how they constructed the database ) it does not place the column name in the parens. Eric P. Melillo Sr. Database Administrator Associated Grocers, Inc. Seattle, WA 98118 vmail: (206) 767-8178 email: eric_melillo@agsea.com "Jung-Hui Cheng" <cheng@dbtel.com.tw> on 12/15/98 09:18:23 PM Please respond to "Jung-Hui Cheng" <cheng@dbtel.com.tw> To: informix-list@iiug.org cc: (bcc: Eric Melillo/AGInc) Subject: Way to determine UPDATE STATISTICS Hi All; Is there a method to determine the rule about update statistics ? For example, what kind of tables should be run "UPDATE STATISTICS HIGH" and others use "LOW". By the way, what is the "RESOLUTION" ? How it work ? Thanks Jung-Hui Cheng cheng@dbtel.com.tw