On Mar 19, 11:46 pm, Serge Rielau <srie...@ca.ibm.com> wrote:
> Ian wrote:
> > Lennart wrote:
> >> Probably a stupid question, but is there an easy way to determine how
> >> much a table has changed since last time stats where updated? What I'm
> >> trying to figure out is whether there is a need to do runstats on a
> >> particular table or not.
>
> >> Thanx
> >> /Lennart
>
> > The DB2 Health monitor tracks this, but I don't think that this is
> > externalized. But you could certainly leverage health monitor to
> > notify you when it thinks a table needs to have its statistics
> > updated.
>
> And in DB2 9.5 you can leave it to DB2 end to end...
>

Thank you Ian and Serge.



/Lennart