calling explain plan in ST05

[Former Member]

Does anyone know how to?

I am trying to find out if these two tables are hitting the primary or secondary indexes.

/BIC/AZBDITM00

/BI0/ASD_O0600

Any help would be appreciated.

[former_member618758 · Accepted solution]

Hi,

The quickest way is in st05, activate trace, and click the enter SQl statement button, enter the sql command for actually accessing these two tables, then click on explain button where you will see if the said indexes are being used or not.

Hope this will help,

George

[Former Member]

answered

[Former Member]

Hi Shawn

Another good possibility apart from an SQL trace is to look for already executed statements in the oracle cursor cache.

ST04 -> Detail analysis menu -> SQL request

Then enter a SQL pattern, e.g. /BIC/AZBDITM00. Now you get all actual statements on this table, you can see the plans by clicking on the statement and then the tool like button. As a bonus you can also jump to the corresponding ABAP coding (will probably not give much in a BI / APO because of the dynamic generated code). You can also see the buffer gets and more there.

Regards

Michael

[Former Member]

Thanks guys.

That solved the issue.