Hi there,

I have a table with over 24 mil rows , I run stats 2 months ago, last
weeek I aplied last fIX pack forDB2UDB, I run a quesry against the table
the performance were worst 30 minutes for a qury that normaly takes 30
sec.
I run explain plan the quesry was not using the MDC index, today I
runstats and same query took 30 sec ...

is DB2 still not using the old runstats if data was not changed since
than ??????


Isabella



DB2 & UDB email list listserv db2-l LazyDBA home page