RE: Update Statistics high vs medium/low

What release of Informix? I've seen many examples of update statistics killing some queries on versions 7.31 up to 7.31uc2xa. I've been running 7.3xuc2xa with a statistics plan of low/drop and medium on non-indexed columns, things are running great. Informix tells me to upgrade IDS to 7.3uc6 to fix optimizer problems. Jerry "Keep Amateur Wrestling Alive!" -----Original Message----- From: Tony Woods [mailto:twoods786@hotmail.com] Sent: Thursday, June 08, 2000 5:29 PM To: informix-list@iiug.org Subject: Update Statistics high vs medium/low Hello gurus, Is it by any chance possible that executing update statistics high will slow down the queries and executing update statistics medium/low will improve the performance. Any kind of help is appreciated. Thanks in advance. Tony Woods. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com