ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  ABAP
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question
Do you use select statement in loop end loop, how will be
the performance? To improve the performance?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Do you use select statement in loop end loop, how will be the performance? To improve the performance?
Answer
# 1
No, It is not recommended to do that as it kills the 
performance.
 
Is This Answer Correct ?    1 Yes 0 No
Jammy
 
  Re: Do you use select statement in loop end loop, how will be the performance? To improve the performance?
Answer
# 2
Best option will be to select the data before loop and 
inside loop use read statement.

select f1 f2 f3(key fields) from db into 
                iNtertab
                for all entries in itab
                       where condition.
sort intertab by f1.
loop at itab.
read intertab with key f1 = itab-f1
                   binary search.
Endloop.
 
Is This Answer Correct ?    1 Yes 0 No
Sukhbir
 
 
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
What is the purpose of Edit Masking? IBM2
where can u find user-exits & bapi? Satyam2
What is a BAdi? How to implement a BAdi? SAP-Labs2
what is the use of CTU_PARAMS hwen we r working with BDC?  2
what is the difference between user-exit & BADIs?  2
I want to display the different data on the multiple main windows of the form in Sapscript. Is it possible ? If yes, then How? Accenture3
How to work on TCODE SE16?  2
how to process the idoc? IBM2
if you want to improve the response time logical database permits you to achive this using?  1
what is direct input method? Keane-India-Ltd1
1)you are creating the table and with EmpID, Lastname and Zender(Male and Female) only the Male and Female data only should entered other data should not entered. EDS1
what is check statement L&T2
how can u write in single program call transaction and session method logic? if u write logic in call transaction ,is there any errors ? how can u see in session ? Satyam1
what are the two types of request available in CTS?  1
How to create our own data types in a Report??  1
what is the flag?  2
what is the unit of work IBM1
what is the transaction code for creating a quotation of sales order SGT1
3. What is table maintaince generator ? How do u do it ? Use of it ? IBM5
What is an Extended IDOC and It's purpose? Sony2
 
For more ABAP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com