Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regarding of using indexes...


I'm wondering if one of my indexes are using or not... we are using the ST05 transaction but dont know how to see if the index is used or not...

Thanks In Advance

Best Regards


Former Member
Former Member replied

The Explain tool shows which index will be used based on what you specify in the Where clause. u2018~0u2019 denotes that the primay key is being used. If the secondary index is used it will be shown here. You can crosscheck in se11 for your table to see exactly which index is used based on the INDEX UNIQUE SCAN.

You can check this blog for addtional info on ST05:

The SQL Trace (ST05) – Quick and Easy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question