During performance analysis you found one select statement
taking long time. How to correct it?

Answer Posted / phani

If we found perticular SELECT Statement is taking long time,
We have to use proper WHERE conditions and have to use KEY
FIELDS at WHERE condition.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

3418


what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march

1662


What are local objects?

627


What is the difference between open_form and close_form?

621


What are conditional chain statement?

751






How can we use multiple transactions by using bdc_insert? : abap bdc

649


What are the two ways for restricting the value range for a domain? : sap abap data dictionary

728


What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary

589


What is the step-by-step process to create a table in data dictionary? : abap data dictionary

700


What are hashed tables?

873


If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary

662


Differentiate between ooabap and abap?

720


I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.

1357


What are datasets in abap?

683


What is the use of table maintenance allowed?

547