Blair you are right, but this is really a problem.
If you review application & index design it is very difficult to decide
which indexes are no longer required. DB2 provides not much help on
this, snapshots are not much help and I think event monitors canīt be
used on large systems for this.
Have you got any advise, whitepaper, internal notes, step-by-step
procedures, etc. which could help for this?
Many thanks
Stefan
Blair Adamache schrieb:
EXPLAIN.
xixi wrote:
we are using db2 udb v8.1 on windows, is there any monitor tool
telling the index frequent usage? so i know which index picked up
most?