Skip to Content
0
Former Member
Oct 30, 2013 at 09:02 AM

How to confirm whether SQL hit indexes?

319 Views

Hi experts,

I wonder if I want to check if one SQL code like "select * from xxx into table xxx where……" will hit index, if not, the select time may cost much time. In my impression, t-code:db02 or db20 will help for this, but I forgot what to do use this t-code. Could you kindly show me what to do if I want to confirm whether SQL will hit index step by step ? Thanks you very much !