Sql tuning

[Former Member]

Hi

Is there any tool in sap that will help me tune my sql statements or give me any alternative suggestions for the query that i am using.

Can any one send me some best practise templates for improving performance of the program and do's and donts in the open sql.my mail id is vecvignesh@yahoo.co.in

[Former Member]

use transaction <b>ST05</b>

[dani_mn]

HI,

go to transaction 'SE30'

in application tool bar there is a button

'Tips and Tricks' click on that.

you will see there different quries and their alternatives ways and also their runtime.

Regards,

Wasim Ahmed

[former_member186741]

ST05. Hit the 'enter sql staement ' button. It will analyse the sql for you.

[Former Member]

hi,

Check this link

<b>Performance tuning for Data Selection Statement & Others</b>

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm

http://www.sapdevelopment.co.uk/perform/performhome.htm

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_Introduction.asp

<b>Please Reward Points & Mark Helpful Answers</b>

To mark Helpful Answers ;click radio Button next to the post.

RadioButtons

<b>o</b> Helpful Answer

<b>o</b> Very helpful Answer

<b>o</b> Problem Solved.

Click any of the above button next to the post; as per the anwers

<b>To close the thread; Click Probelm solved Radio Button next to the post , which u feel is best possible answers</b>

[Former Member]

Hi,

you can make use of,

SE30 : Run time analysis, to get a measure of the database time the program is consuming.

ST05:activate SQL trace, in trace analysis select summarization by SQL statements,from this you can find out the SQL stmt consuming maximum time & there upon decide on it & tune it.

Regards,

Raghavendra

[Former Member]

Hi,

Yes u can use TXN- SE30 der u hv an option of tips and tricks u can use tht as well as analyse ur code u can also use TXN- ST05 activate trace then execute ur prog trace off and then list the trace this will tel u how much time its taking to fetch the data also u can create secondary indexes for the table fields u hv used in where condition.

hope this helps.

Regards,

Seema.

[aris_hidalgo]

Hi,

Please check out transactions ST05, SE30, If you have Code inspector use that as well. Also, you can search topics here in SDN that has the same topics. It will give you more ideas on SQL tuning.

Hope this helps...

P.S. Please award points for useful answers.