How to check Index in SAP system
Go to T- Code : se11
Enter table name for which you want to check the indexes.
Click on Display. Here you find all the columns/ fields that it has.
In this, Click on Indexes. Now, you can find all the indexes for the table.
Click on execute and you finds the fields for that belongs to this index.
This can be helping you in performing issue, time then identified the respective table for that the query.