SE30 Runtime Analysis - To Find Index Usage

[Former Member]

Hi All,

I ran out Run Time Analysis for a Program. When Analysing the calls, FETCH MSEG is taking much time.

Now I want to know which INDEX is taken for this MSEG FETCH.

Where I can find this in SE30 transaction.

Regards,

Viji.

[Former Member]

You will find the index in the execution plan of your select statement.

Click on your statement in SE30 output > Do Explain>

Now in the execution plan look for INDEX UNIQUE SCAN it shows the index used next to it.

[Former Member]

I am working with 4.6C.

In SE30 I gave the Program Name --> Execute.

BACK > Analyse> Runtime Analysis Evaluation Overview

On Pressing Icon HIT LIST --> The List will be displayed with CALL, GROSS, PROGRAM NAME, NET.

Now where can I find the Index used?

Help me out?

Regards,

Viji

[Former Member]

I think you will have to use ST05 to find the index used.

Once you display the result if the trace, choose your select statement and do explain

[Former Member]

Thanks.