Mysterious update statistics

Posted in 2008

Habichtsberg, Reinhard — Mon, 14 Apr 2008 11:14:51 +0200 — source: Usenet: comp.databases.informix

Hi all. Once again a question to update statistics: Makes it a difference how many data had changed between two runnings e.g. UPDATE STATISTICS FOR TABLE xxx; In other words: Is update statistics aware of the difference or is it running on all data at all times? Would it make sense to shorten the interval between two runnings to shorten the time of the runnings? And is the behaviour the same for low, medium high (distributions only)? The tables in question are rather big (between 10 Million and more than a billion rows with a couple of indexes) and it's difficult to run update statistics in an adequate time so I have to find a strategy... TIA, Reinhard.