Hi ,
Sorry for such a long delay..but the issue was somehow sidelined
When i try to refresh my table i found that it is using a MQT that was created for reporting purposes.
Any MQT that is refresh deferred, but is made available for query optimisation needs to be kept in-line with the underlying data. Otherwise a query that is redirected to the MQT may give inconsistent results against queries that do not get redirected.
...

yes i did that..
i did a count on the txn_key
i used the txn_key too as a pivot
i.e
i took the record counts <= a particular value and greater than it.
The record counts still fall short of the original value

Hi,
I am working on db2 and i have this table A
It has the following columns
TXN_KEY
TXN_DATE

there are some more but they are not required here

When i run a count(*)
db2 "select count(*) from A"

1
-----------
199854786

But suppose i run a query like

db2 "select count(*) from A where TXN_DATE<='20/06/2007'"...