Which table index is used by query ?

[Former Member]

HI,

Is there any tool through which we can know the index used by a query.

Thanks.

[Former Member]

HI,

TRY IT OUT IN ST05 SQL TRACE ANALYSES

[Former Member]

Hi,

Through ST05 transaction, you can activate Trace and Display result.

If you summarize it by SQL Query you can See the indexes used by query.

Reward if helpful!

[Former Member]

But it provide a list of all indexes

I want to know about the specifec index used by the query.

[Former Member]

Hi

By default each table will have a Primary index based on its key fields

that's why it is always suggested to use the primary key fields in the select query while selecting the data from that table

when we are using some other fields other than key fields we generally create a secondary index and use those fields in the where conditions.

check the tables

DD12L

DD12MSS

DD12T

DD17S

DD90L

DD90T

DD91S

DD92S

and also by using the ST05 Tcode

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

hi,

Check the index of that table.

goto SE12. give table name and display.

in application tool bar select indexes. Here you can see the indexes of that table.

Now compare the index field with field used in Select statement where condition.

I think there is no seperate tool for this....

Kishi.