查看表结构添加索引

查看tablebname表结构
     db2look -d databasename -e -t tablebname(注：ALLOW为双向索引，DISALLOW为单向索引。)
     过滤查看数据库表名
     db2 list tables for schema TMISUSR|grep -i job
     添加索引举例：
     DROP INDEX IX_TMVG_FINASTOCK_TMP;
     CREATE INDEX IX_TMVG_FINASTOCK_TMP ON TMVG_FINASTOCK_TMP(D_ACCT ASC,S_UPTRECODE ASC,S_TRECODE ASC)  
     DISALLOW REVERSE SCANS ;