[记事考古] DB2 DMS后的灵异事件
 |
trydofor
2010-05-18
2010-05-13,不得不说，这次见鬼了。
select count(*) from HISTORYLOANTRANSACTIONITEM HLTI go // 15398137 select HLTI.LOANBALAMOUNT from HISTORYLOANTRANSACTIONITEM HLTI where LOANCONTRACTID = '00000000000003449907' go // >>10 min 仍没有结果 select HLTI.PROCESSDATE from HISTORYLOANTRANSACTIONITEM HLTI where LOANCONTRACTID = '00000000000003449907' go //125 ms select HLTI.* from HISTORYLOANTRANSACTIONITEM HLTI where LOANCONTRACTID = '00000000000003449907' go // 125 ms |
 |
iamwave
2010-05-20
这个问题解决了吗？
|
 |
paolo1818
2010-05-20
LOAD数据后，一定要进行runstats,更新表和索引的统计信息，由其是数据量大的表
尤为重要。 db2 runstats on table db2inst1.HISTORYLOANTRANSACTIONITEM with distribution and detailed indexes all |
 |
leon_a
2010-06-01
路过
|
