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 insert a line into abap internal tables?

610


what is difference between set screen and call screen ?

550


How to debug rfc function module?

684


What is the significance of technical settings (specified while creating a table in the data dictionary) ?

578


What is the use of 'table index'?

623






– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required:  Sales Org  Delivery type  Sales document type Optional:  Planned Goods movement date  Option to choose E-Mail  E-mail Address  Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields,  Success/Error (S/E)  Sales Document number  Delivery number  New Debit memo request number  Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS

5520


What abap statement will trigger list generation?

621


singleton class

926


1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?

6630


what is sap scriptview ?

1730


What is static attribute

1072


What is the difference between select statement and provide statement ? : abap hr

563


How to debug a sapscript?

593


What is an evaluation path? : sap abap hr

549


What are Pull and Push Methods?

1768