Re: Update statistics...anytime?

Clem Akins <clem@informix.com> writes: > 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.) This seems to be the same for 7.14 The table is _not_ locked exclusively. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694