update statistics

Posted in 2007

Bill64bits — Sun, 4 Mar 2007 17:47:55 -0600 — source: Usenet: comp.databases.informix

The IBM web page at http://www-1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHMMC&context=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=SSGHZP&context=SSVT2J&q1=update+statistics&uid=swg21137764&loc=en_GB&cs=utf-8&lang= says to update statistics thusly: 1. Run UPDATE STATISTICS LOW on all tables in the database. 2. Run UPDATE STATISTICS MEDIUM on all columns which are in an index, but are not the first column of any index. 3. Run UPDATE STATISTICS HIGH on all columns which are the first column in an index. 4. Run UPDATE STATISTICS on all stored procedures. I thought someone on this group propounded the proper sequence as 1. medium on all tables 2. high on heads of indexes 3. medium on tails Which is correct?