News
Abstract
Index Statistical Catalogs - enhanced to return more detail
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Index Statistical Catalogs - enhanced to return more detail
Which catalogs changed?
1) QSYS2.SYSINDEXSTAT – contains one row for every SQL index partition.
2) QSYS2.SYSPARTITIONINDEXES – one row for every index built over a table partition or table member.
3) QSYS2.SYSPARTITIONINDEXSTAT – one row for every index built over a table partition or table member. Indexes that share another index’s binary tree are not included.
What was added?
• Last_Build_Type – An indication of whether the last index build relates to a complete build or delayed maintenance build
• Last_Invalidation_Timestamp – An indication of when the index was last invalidated.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
22 January 2020
UID
ibm11168276