Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: List Count of Indexes

    Hello,

    Is there a function or possibility that I can list all my indexes and how often they have been used in DB2?

    Thanks in advance....

    DB_NOOB

  2. #2
    Join Date
    Aug 2011
    Posts
    46
    db2pd -d <dbname> -tcbstats all , see column "Scans".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •