TBLSTATS

Posted in 2003

Ravi Krishna — Mon, 1 Dec 2003 11:41:20 -0500 — source: Usenet: comp.databases.informix

How much is the performance penalty for setting TBLSTAT to 1. I need to do some analysis for capacity planning. I vaguely remember that there will be a 5% performance degradation and I think I can live with it. Has anyone experienced something different, for better or worse. TIA.

↪ replying to Ravi Krishna

John Carlson — Mon, 01 Dec 2003 12:26:42 -0500 — source: Usenet: comp.databases.informix

On Mon, 1 Dec 2003 11:41:20 -0500, "Ravi Krishna" <ravik_dba@yahoo.com> wrote: >How much is the performance penalty for setting TBLSTAT to 1. I need >to do some analysis for capacity planning. I vaguely remember that >there will be a 5% performance degradation and I think I can live with >it. Has anyone experienced something different, for better or worse. > >TIA. > Haven't noticed any issues here, but then I use it continually for capacity planning . . . .