Can we have all the SQL statements run for last 2 days to check indexes use

[Former Member]

Hi,

Does SAP system register any SQL statements in the database with the index utlization status? We are considering data for last 2 days.

We are in the midst of performance tuning, and want to know if the indexes are being utlized properly.

Any good ideas?

Thank you in advance.

cheers

Chander

[Former Member · Accepted solution]

Hi,

We can trace all the sql statements ran via tcode st01. Activate the sql trace in st01 for this .

For details pl refer http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/content.htm.

Havent explored if there is another way around.

Pl dont forget to award suitable points.

Regards

[Former Member · Accepted solution]

Hi Pattnaik,

Thank you for the quick response.

I will go thru the suggested option, if it is a workable solution for me, and then I will update you.

Thank you once again.

Regards

Chander

[Former Member · Accepted solution]

Hi Pattnaik,

Thank you for the answer. It fits my requirment currently.

Regards

Chander