Re: Update stats for 7.2x

Posted in 1997

Mark D. Stock — Mon, 08 Dec 1997 15:27:09 +0200 — source: Informix-list mailing list archive (1991-1998)

W. H. SMITH wrote: > > Sorry for the confusion. > > I understand the Informix recommendations; I've implemented them for > the > 7.13 engine we are currently using. I just thought that I saw some > 'other' recommendations (different for 7.2x from 7.1x) in this > newsgroup. I think you may be referring to the recommendation to UPDATE STATISTICS HIGH for each column in a composite index that makes it unique. For the following indexes: a, b, c, d, e, f a, b, c, g You would UPDATE STATISTICS HIGH for columns a, b, c, d, & g. Is that what you meant? Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+