Re: Update statistics...anytime?

Posted in 1998

Clem Akins — Mon, 02 Feb 1998 15:59:06 -0800 — source: Informix-list mailing list archive (1991-1998)

John Carlson answers: >Update statistics will lock the table in exclusive mode. It should>really take place when no one is on the system. We run our scripts >overnight. As of OnLine version 7.2? the UPDATE STATISTICS command places a much less restrictive lock on the table. There is still a penalty in performance as the engine reads the data, and the small possibility that your application will try to use the statistics at the exact instant they are being updated (in which case the app will fail and should re-try.) ___________________________________________________________ Clem Akins (aka clem@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Beachside, recharging solar batteries in Oz, mate!