DB2 index related qusn

[sumeet1]

Hi

How to find out indexes on a table using SQl query....


some thing like :

show indexes on tab_name;

or

select indexes on tab_name;

thanks
Sumeet

[Mondo Tofu]

SELECT TBNAME, NAME FROM SYSIBM.SYSINDEX ES
GROUP BY TBNAME, NAME;

Good luck.
Mondo Tofu