Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

Chapter 5. Database > IBM OmniFind Text Search Server for DB2 for i5/OS - Pg. 102

Contains one row for every index that has at least one partition or member built over a table. If the index is over more than one partition or member, the statistics include all those partitions and members. SYSTABLESTAT Contains one row for every table that has at least one partition or member. If the table has more than one partition or member, the statistics include all partitions and members. SYSINDEXSTAT Contains one row for every SQL index. Use this view when you want to see information for a specific SQL index or set of SQL indexes. SYSMQTSTAT Contains one row for every materialized table. Use this view when you want to see information about a specified materialized query table or set of materialized query tables. SYSPACKAGESTAT Contains one row for each SQL package in the SQL schema. SYSPARTITIONMQTSTAT Contains one row for every index built over a table partition or table member. Use this view when you want to see index information for indexes built on a specified table or set of tables. SYSPROGRAMSTAT Contains one row for each program, service program, and module that contains SQL statements. The information returned in SYSINDEXSTAT, SYSMQTSTAT, SYSPARTITIONINGINDEXES,