index hit

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • xixi
    #1

    index hit

    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?
    Tags: None
    • Blair Adamache
      #2
      Re: index hit

      EXPLAIN.

      xixi wrote:
      [color=blue]
      > 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?[/color]

        Comment

        • Stefan Kraemer
          #3
          Re: index hit

          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:[color=blue]
          > EXPLAIN.
          >
          > xixi wrote:
          >[color=green]
          >> 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?[/color]
          >
          >[/color]

            Comment

            • Blair Adamache
              #4
              Re: index hit

              If you run the Index Advisor (comes up under the Design Advisor in v8 I
              think) it can tell you which indexes are not required if you have an
              accurate picture of your workload.

              Stefan Kraemer wrote:[color=blue]
              > 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:
              >[color=green]
              >> EXPLAIN.
              >>
              >> xixi wrote:
              >>[color=darkred]
              >>> 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?[/color]
              >>
              >>
              >>[/color][/color]

                Comment

                Previous template Next
                Working...