查看一个表的索引
db2 "
SELECT
substr(tabname,1,20) as tabname,
substr(indschema, 1, 20) as indschema
    ,substr(indname, 1, 20) as indname
    ,substr(UNIQUERULE, 1, 1) as UNIQUERULE
    ,substr(COLNAMES, 1, 60) as COLNAMES
FROM syscat.indexes
WHERE tabschema = 'EPRICER'
    AND tabname = 'CTMTOPGMAP'"
查看哪些表的外键列上没有建立索引
SELECT fkeys.tabname ,fkeys.constname ,fkeys.colname ,ind_cols.indname FROM ( SELECT a.tabschema ,a.tabname ,a.constname ,b.colname FROM syscat.tabconst a ,syscat.keycoluse b WHERE a.tabschema = 'EPRICER' AND a.type = 'F' AND a.tabname = b.tabname AND a.tabschema = b.tabschema ) fkeys LEFT JOIN ( SELECT a.tabschema ,a.tabname ,a.indname ,b.colname FROM syscat.indexes a ,syscat.indexcoluse b WHERE a.indschema = b.indschema AND a.indname = b.indname ) ind_cols ON ( fkeys.tabschema = ind_cols.tabschema AND fkeys.tabname = ind_cols.tabname AND fkeys.colname = ind_cols.colname ) WHERE ind_cols.indname IS NULL