topic Re: Does my open SQL use index or not? in Application Development and Automation Discussions

Does my open SQL use index or not?

sagar-acharya — Mon, 21 Nov 2005 09:49:29 GMT

Hi folks,

I have a SELECT on GLPCT table which has an index over 5 fields. I am specifying them in my SELECT, but where do I see if the index is really being used? Leave the run time apart, any transaction code?

/Sagar

Re: Does my open SQL use index or not?

athavanraja — Mon, 21 Nov 2005 09:57:06 GMT

you have to use either ST05 or se30 to find whether the statement has used the index or not and which index is used.

I guess you wont find a transaction which can tell you in design time whether the index will be used or not as index usage is determined by databased optimizer at runtime.

in your case if you are specifying all the 5 fields of the index in your select (without <> operator) in your select stt. most probably the index will be used.

Regards

Raja

Re: Does my open SQL use index or not?

Former Member — Mon, 21 Nov 2005 10:03:17 GMT

You Can Use INDEXes , You Can See Them in SQL trace.

Regards

Vijay

Re: Does my open SQL use index or not?

sagar-acharya — Thu, 07 Aug 2008 06:17:31 GMT

In ST05, there is a little button called 'Explain'. That provided the information about index being used.