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...

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab