Skip to Content
0

SQL Trace explain functionality is not showing Index as it shows before in 702 release

Apr 25, 2017 at 03:38 PM

72

avatar image
Former Member

Hello Experts,

I want to check the Table index used in SQL statement using explain where i can check that in my system before SAP 702 release.But after SAP_ABA 702 release, SP-15 in our system i can't.

I can't able to see the old screen of T-Code 'ST05' for "Explain" functionality where it will shown index used.

Some different screen with tree is showing instead old one where i cant find used Index in SQL statement.

Please let me know any note to implement or how to check used Index for a Table using Explain function in SQL Trace list.

Please find the attached old and new explain screen shots.

sql-trace-explain-before-702.png

sql-trace-explain-after-702.png

Thanks in advance,

Sai karthik

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sandra Rossi Apr 25, 2017 at 07:14 PM
1

For your SP of 7.02 I don't know, but in recent releases (7.31/7.40), you have the choice between the old and the new format of Explain (If I'm not wrong, the old format is the default one). You should look for SAP notes which maybe correct this or add a button to switch between old/new displays.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Sandra,

Thanks for your response.

Could you please help me to know if any Note is there for the problem.

0
Jelena Perfiljeva
Apr 25, 2017 at 08:16 PM
0

We have 7.01 and 7.31 systems. When I do ST05 -> display trace -> Explain the screen looks the same in both systems. It seems that your "after" screenshot actually shows something completely different since it reads "Database performance". I'd guess you just arrived there doing different steps or some of the settings are different.

7.01 (I used VA05 transaction as an example):

7.31:


st05-old.jpg (94.4 kB)
st05-new.jpg (94.7 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Jelena,

I have navigated through the SQL Trace->Explain only.Attached screenshot for the same.

Could you please let me know where to check the settings as suggested by you in the reply.

sql-trace-naviagte-explain.png

Thanks,

Sai karthik.

0