Solved: hai abap gurus...

Former Member · ‎2007 May 29

What is performance tuning?

What are steps you follow to improve the performance of

a report ?

what is the role of secondary index in performance?

what is the role of ST05 in performance tuning?

what is the role of extended syntax check in

performance tuning?

will join conditions in sql queries affect perfomance? how?

will sorted internal tables help in performance?

will where conditions in a sql query help improve

performance?

does select single *.. / select * .. affect performance ?

how?

Former Member · ‎2007 May 29

hi,

Performance Tuning : It is nothing but improving the performance of the code using better coding.

Secondary Index are mainly used to link the next table using Key Id's ...it increses the speed while fetching data.

ST05 is transaction code for SQL Tace....By using this we can Know how efficiently Query is running for a given report.

Using Joins the performance will be increased as it will not fetch the redundant data.

Sorted Internal tables mainly used whereever More sorting is required.

Where Condition is mainly used to restrict values using some condition.So only required data will be fetched..it will improve performance.

select single * in a query increases the performance of report as it fetches one record based on given condition.

Reward with Points if helpful.

Former Member · ‎2007 May 29

hi,