データベース・モニター・ビュー 3001 - 使用された索引

Create View QQQ3001 as 
  (SELECT QQRID as Row_ID, 
          QQTIME as Time_Created, 
          QQJFLD as Join_Column, 
          QQRDBN as Relational_Database_Name, 
          QQSYS as System_Name, 
          QQJOB as Job_Name, 
          QQUSER as Job_User, 
          QQJNUM as Job_Number, 
          QQI9 as Thread_ID, 
          QQUCNT as Unique_Count, 
          QQUDEF as User_Defined, 
          QQQDTN as Unique_SubSelect_Number, 
          QQQDTL as SubSelect_Nested_Level, 
          QQMATN as Materialized_View_Subselect_Number, 
          QQMATL as Materialized_View_Nested_Level, 
          QVP15E as Materialized_View_Union_Level, 
          QVP15A as Decomposed_Subselect_Number, 
          QVP15B as Total_Number_Decomposed_SubSelects, 
          QVP15C as Decomposed_SubSelect_Reason_Code, 
          QVP15D as Starting_Decomposed_SubSelect, 
          QQTLN as System_Table_Schema, 
          QQTFN as System_Table_Name, 
          QQTMN as Member_Name, 
          QQPTLN as System_Base_Table_Schema, 
          QQPTFN as System_Base_Table_Name, 
          QQPTMN as Base_Member_Name, 
          QQILNM as System_Index_Schema, 
          QQIFNM as System_Index_Name, 
          QQIMNM as Index_Member_Name, 
          QQTOTR as Table_Total_Rows, 
          QQREST as Estimated_Rows_Selected, 
          QQFKEY as Index_Probe_Keys, 
          QQKSEL as Index_Scan_Keys, 
          QQAJN as Estimated_Join_Rows, 
          QQEPT as Estimated_Processing_Time, 
          QQJNP as Join_Position, 
          QQI1 as DataSpace_Number, 
          QQC21 as Join_Method, 
          QQC22 as Join_Type, 
          QQC23 as Join_Operator, 
          QQI2 as Index_Advised_Probe_Count, 
          QQKP as Index_Probe_Used, 
          QQI3 as Index_Probe_Column_Count, 
          QQKS as Index_Scan_Used, 
          QQDSS as DataSpace_Selection, 
          QQIDXA as Index_Advised, 
          QQRCOD as Reason_Code, 
          QQIDXD as Index_Advised_Columns,
          QQC11 as Constraint, 
          QQ1000 as Constraint_Name,  
          QVQTBL as Table_Name, 
          QVQLIB as Table_Schema, 
          QVPTBL as Base_Table_Name, 
          QVPLIB as Base_Table_Schema,
          QVINAM as Index_Name, 
          QVILIB as Index_Schema,  
          QVBNDY as Bound, 
          QVRCNT as Unique_Refresh_Counter, 
          QVJFANO as Join_Fanout, 
          QVFILES as Join_Table_Count, 
          QVPARPF as Parallel_Prefetch, 
          QVPARPL as Parallel_Preload, 
          QVPARD as Parallel_Degree_Requested, 
          QVPARU as Parallel_Degree_Used, 
          QVPARRC as Parallel_Degree_Reason_Code, 
          QVCTIM as Estimated_Cumulative_Time,
          QVc14 as Index_Only_Access, 
          QQc12 as Index_Fits_In_Memory, 
          QQC15 as Index_Type, 
          QVC12 as Index_Usage, 
          QQI4 as Index_Entries, 
          QQI5 as Unique_Keys, 
          QQI6 as Percent_Overflow, 
          QQI7 as Vector_Size, 
          QQI8 as Index_Size, 
          QQIA as Index_Page_Size, 
          QVP154 as Pool_Size, 
          QVP155 as Pool_Id, 
          QVP156 as Table_Size, 
          QQC16 as Skip_Sequential_Table_Scan, 
          QVC13 as Tertiary_Indexes_Exist, 
          QVC3001 as DataSpace_Selection_COlumns, 
          QQC14 as Derived_Column_Selection, 
          QVC3002 as Derived_Column_Selection_Columns, 
          QVC3003 as Table_Columns_For_Index_Probe, 
          QVC3004 as Table_Columns_For_Index_Scan, 
          QVC3005 as Join_Selection_Columns, 
          QVC3006 as Ordering_Columns, 
          QVC3007 as Grouping_Columns, 
          QQC18 as Read_Trigger, 
          QVP157 as UDTF_Cardinality, 
          QVC1281 as UDTF_Specific_Name, 
          QVC1282 as UDTF_Specific_Schema, 
          QQC13 as MQT_Replacement, 
          QQSMINTF as Plan_Iteration_Number, 
          QVC3008 as Include_Values, 
          QVC15 as Sparse_Index, 
          QQF1 as Average_Read_Time,
          QVC11 as Distinct_Indicator
   FROM   UserLib/DBMONTable 
   WHERE  QQRID=3001)