Re: UPDATE STATISTICS

Posted in 1997

SaTriGuy — 26 Apr 1997 05:05:31 GMT — source: Informix-list mailing list archive (1991-1998)

>Subject: UPDATE STATISTICS >Why doesn't the engine UPDATE STATISTICS automatically? That would create a bottleneck. If each change by each transaction was followed by an alteration to a systable, then in effect each and every transaction would be creating a table-level lock. This would then be compounded by the question of rollbacks. >Does anyone have any ideas regarding the logistics of running of UPDATE >STATISTICS in a 24 hour environment? >Thank you and please also reply via email. Madison Pruet