Hi Bokka,
The following will show you the indexes for a table.
SHOW TABLE DATABASENAME.TABLENAME;
Attachments
Library
Quick Reference
Archives
Sample Index
2007 Indexes