topic Re: ST05 in Application Development and Automation Discussions

ST05

Former Member — Fri, 09 Jan 2009 09:39:19 GMT

When i m executing ST05 there is a option "Enter SQL statement".

When i paste my sql statement and click on explain button, i am getting following error.

"Error recieved from Explain SQL"

Please help

Regards,

Santosh

Re: ST05

Former Member — Fri, 09 Jan 2009 09:48:27 GMT

Hello,

this function requires native sql - like you would write it between exec sql and endexec.

Or like you could copy from an sql trace.

Regards Wolfgang

Re: ST05

Former Member — Fri, 09 Jan 2009 10:11:49 GMT

Hi Santosh ,

Check if you are using correct fields of a table and try to use modifed version of any existing statements.

To check if this option is working in your system :open any exiting statement with "Explain" and save it as local file.

Now open another statement and press F5 ; this will clear your editor . After this Load the saved file and click on Explain button.

This editor can be used to check the cost and index used for a valid database statements.

Thanks,

Tushar

Re: ST05

Former Member — Fri, 09 Jan 2009 10:12:51 GMT

Hi,

You have to enter Native SQL Statement there.

Follow below steps:

Run Tcode 'ST05' -> activate trace -> run your program ->wait till execution -> deactivate trace -> display trace -> find ur select statement there -> position on it -> press EXPLAIN -> whatever sql query you find there copy it and paste it in 'Enter SQL Statement Area' .

Hopes this helps you to write Naitive SQL query.

Regards,

Nibha

Re: ST05

Former Member — Fri, 09 Jan 2009 15:17:48 GMT

I must cases you would anyway post your original statement there ...

so what will change ????

The function is mainly interesting to check whether the explain changes

+ after an update of the statictics

+ or after the creation of a new index

+ or by adding a suitable database hint

Siegfried