09-07-2007 10:35 AM
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
09-07-2007 11:22 AM
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>
09-07-2007 10:38 AM
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.
09-07-2007 11:22 AM
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>