Does my open SQL use index or not?

[sagar-acharya]

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

[sagar-acharya]

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

[athavanraja]

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

[Former Member]

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

Regards

Vijay

[sagar-acharya]

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