
复制db2 "create table t1 (col1 int) compress yes" db2 "create index idx_col1 on t1(col1) " db2 "select substr(INDNAME,索缩新1,18),substr(TABNAME,1,18),COMPRESSION,PCTPAGESSAVED from syscat.indexes where tabname=T1" 1 2 COMPRESSION PCTPAGESSAVED IDX_COL1 T1 Y -1 1.2.3.4.5.6.7.