RE: UPDATE STATISTICS questions

Posted in 1999

Marichamy, Udaykumar — Tue, 20 Apr 1999 12:09:30 -0500 — source: Informix-list mailing list archive (1991-1998)

-----Original Message----- From: Dick.Brieck@chase.com [mailto:Dick.Brieck@chase.com] Sent: Monday, April 19, 1999 3:35 PM To: informix-list@iiug.org Subject: UPDATE STATISTICS questions I've a couple of basic questions: 1) Are distributions created only by UPDATE STATISTICS MEDIUM or HIGH? YES. 2) Is UPDATE STATISTICS HIGH or MEDIUM followed by dropping distributions the same result as just doing UPDATE STATISTICS LOW? If not, what are the differences? NO. The DROP DISTRIBUTIONS clause drops previously generated data distribution statistics. This clause can be used with LOW, MEDIUM and HIGH options. Thanks for your time, Dick Brieck DBA, Chase Manhattan Mortgage Corporation