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 genernate 21 sencondary index

7596


What is the difference between dialog program and a report?

806


What are the types of bdc s?

749


What are the data types of the abap/4 layer?

904


Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?

1783






What are the parameters used in each function?

766


What is the sap abap?

817


What is a badi?

725


How do you display a data in a detail list?

760


What has to be done to the packed fields before submitting to a BDC session.

916


please give the remaining answers.

1958


I need the coding for BDC program to upload Purchase orders of known vendor (ME21) in Material Management

1966


What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc

804


Did you use buffering?

778


What abap statement will trigger list generation?

790