db2 udb 8.2忽略索引 [英] db2 udb 8.2 ignores indexes

问题描述

我最近从8.1.4升级到8.2.3。系统明显放慢了b $ b b。说明显示不使用索引。我对

索引和表进行了重新编制，收集了关键字段的统计信息，详细样本

，所有索引都没有改进。


任何帮助都会有很大的吸引力。


提前谢谢。

I''ve recently upgraded from 8.1.4 to 8.2.3. System slowed down
noticably. Explain shows that indexes are not used. I did reorgs on
indexes and tables, collected stats on key fields with detail sample
for all indexes with no improvement.

Any help would be greatly appretiated.

Thank you in advance.

推荐答案

" romicva" < RO ***** @ gmail.com>在消息中写道

news：11 ********************** @ z14g2000cwz.googlegr oups.com ...

"romicva" <ro*****@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

我最近从8.1.4升级到8.2.3。系统明显放慢了速度。说明显示不使用索引。我对
索引和表进行了重新编制，收集了关键字段的统计信息，并为所有索引提供了详细的样本，没有任何改进。

任何帮助都会有很大的吸引力。

提前谢谢。

I''ve recently upgraded from 8.1.4 to 8.2.3. System slowed down
noticably. Explain shows that indexes are not used. I did reorgs on
indexes and tables, collected stats on key fields with detail sample
for all indexes with no improvement.

Any help would be greatly appretiated.

Thank you in advance.

我认为你的意思是某些以前使用过的索引不会长期使用
。你能发一个详细的例子吗？

I assume that you mean "some" indexes that were previously used are no
longer used. Can you post a detailed example?

我怀疑如果我们所有人都有问题打开PMR，我们只会引起关注直到IBM最终接受他们确实有一个

问题。我们的尝试失败了，但音量可能会有所帮助。


" romicva" < RO ***** @ gmail.com>在消息中写道

news：11 ********************** @ z14g2000cwz.googlegr oups.com ...

I suspect we are only going to get attention on this if all of us with the
problem open PMRs until IBM finally accepts that they really do have a
problem. Our attempt failed, but volume may help.

"romicva" <ro*****@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

我最近从8.1.4升级到8.2.3。系统明显放慢了速度。说明显示不使用索引。我对
索引和表进行了重新编制，收集了关键字段的统计信息，并为所有索引提供了详细的样本，没有任何改进。

任何帮助都会有很大的吸引力。

提前谢谢。

I''ve recently upgraded from 8.1.4 to 8.2.3. System slowed down
noticably. Explain shows that indexes are not used. I did reorgs on
indexes and tables, collected stats on key fields with detail sample
for all indexes with no improvement.

Any help would be greatly appretiated.

Thank you in advance.

Hello Mark，我可以提供什么样的信息？

谢谢。

罗马。

Hello Mark, what kind of information can I provide?
Thank you.
Roman.

这篇关于db2 udb 8.2忽略索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！