SAP Knowledge Base Article - Preview

3585060 - DB6: Performance issue following changes to table structure including new or re-created indexes.

Symptom

A query/program which ran without issue previously is now performing poorly.
Checking the query EXPLAIN plan in the DBAcockpit EXPLAIN overview, the query is expensive for a table access.


Read more...

Environment

Db2 LUW IBM

Keywords

Performance, stats, enabled, runtime, customer field, custom include, table growth, data distribution, IXAND, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.