Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to check index cathing or not

Former Member
0 Kudos

Hi all

How to check querry is catching index(in one report) or not and how to check the statistics of the querry like explain plan in ORACLE.

Thanks

1 ACCEPTED SOLUTION

varma_narayana
Active Contributor
0 Kudos

Hi Phani.

You can check whether a Query is using INDEX or Not in SQL Trace Tcode : ST05.

So perform SQL Trace on this Report and You have a button Explain where you can find whether the query used any index.

<b>Reward if Helpful</b>

2 REPLIES 2

Former Member
0 Kudos

DATA: lh_index LIKE lf_fieldcat-col_pos.

MODIFY t_itab1 INDEX <b>hold_tabix</b> FROM wa_itab1.

READ TABLE t_itab1 INTO wa_itab1 INDEX rs_selfield-tabindex.

Using this u can track.

varma_narayana
Active Contributor
0 Kudos

Hi Phani.

You can check whether a Query is using INDEX or Not in SQL Trace Tcode : ST05.

So perform SQL Trace on this Report and You have a button Explain where you can find whether the query used any index.

<b>Reward if Helpful</b>