how to find all indexes available on table in db2
+2
A:
db2 "select * from syscat.indexes where tabname = 'your table name goes here' and tabschema = 'your schema'"
Ingo
2010-05-20 11:07:46
+1
A:
You can also execute:
DESCRIBE INDEXES FOR TABLE SCHEMA.TABLE SHOW DETAIL
Ian Bjorhovde
2010-05-20 16:58:26