Re: Q: Update statistics

Posted in 1998

WF Software — 8 Sep 1998 18:06:36 GMT — source: Informix-list mailing list archive (1991-1998)

In article <6t2986$9th$1@news.xmission.com>, SusanE@fclcis.co.nz (Susan Elliott (ISG)) wrote: > > Howdy folks, > > What is the effect to the users if they are using the system while > running update statistics is running ? What is, if any is the effect to > my update statistics ?? > > TIA > Suze > > Depending on the size of the tables involved and the level of stats you are doing the users will get intermittent locking problems or will be locked out of the database for a considerable period. If you are using SPL there is a very good chance you'll hit 211 errors on the sysprocplan table which will definitely upset the system Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #