What is the command to see the existing indexes on a DB2 table.


Thanks
Dss

SELECT INDNAME, DEFINER, TABSCHEMA, TABNAME,
COLNAMES, COLCOUNT, UNIQUERULE, INDEXTYPE
FROM SYSCAT.INDEXES
WHERE TABSCHEMA NOT LIKE 'SYS%' AND
TABNAME = 'TABLE_NAME'

SOURCE: http://www.devx.com/dbzone/Article/29585/0/page/4

Thanks,
Newbie

Assuming DB2 for LUW (please give DB2 version and OS next time):

SELECT indschema,INDNAME from syscat.indexes where tabname = 'MYTABLE' and tabschema = 'MYSCHEMA'

Andy

describe indexes for table ... [show detail]