maybe large tables - so there is a delay between data stats and index stats and might be there is a slight difference ..because in the mean time rows have been added/deleted...
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
First, this is just a warning. It just means that you table stats and index stats are out of sync. This is usually caused by just doing runstats on just the indexes or just the table. You can figure out which tables are possibly out of sysnc by comparing syscat.tables.stats_time and syscat.indexes.stats_time.
The best solution is just to do runstats on the table and indexes at the same time with one runstats command.