我在DB2上创建了一个MQT,顺序为:
1. 创建MQT
2.refresh MQT
3.create index on the MQT
4. runstats the MQT
但是第3步执行的时候出现报错信息:
SQL2314W Some statistics are in an inconsistent state. The newly collected
"INDEX" statistics are inconsistent with the existing "TABLE" statistics.
SQLSTATE=01650
查看该索引创建成功了,不知道是怎么回事,请问该怎么办呢?
收起