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   To Refer this Site to Your Friends   Click Here
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 
In an Internal Table, I have 1000 records. I have to 
Retrieve One Record. In Performence wise what is the Best 
Query?
 Question Submitted By :: Sunayana
I also faced this Question!!     Rank Answer Posted By  
 
  Re: In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what is the Best Query?
Answer
# 1		 
Use READ TABLE STATEMENT

READ TABLE <ITAB> INDEX 1.
 
Is This Answer Correct ?    0 Yes 0 No
Sathish
 
  Re: In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what is the Best Query?
Answer
# 2		 
Select Single (with full primary key) is the best process 
to fetch one record.
 
Is This Answer Correct ?    1 Yes 2 No
Niladriroy_dgp
[ECIL]
 
 
 
  Re: In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what is the Best Query?
Answer
# 3		 
select single * is the best query
 
Is This Answer Correct ?    1 Yes 1 No
Shruthi
 
  Re: In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what is the Best Query?
Answer
# 4		 
READ TABLE ITAB WITH INDEX 1. is the best procedure.
 
Is This Answer Correct ?    0 Yes 2 No
Ajay Chowdary
 
  Re: In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what is the Best Query?
Answer
# 5		 
1.READ TABLE ITAB WITH INDEX F1


2.Loop at itab where f1 and f2

  -----

  endloop.

out of these two the second has got the best performance
then the first one.
 
Is This Answer Correct ?    1 Yes 0 No
Medepalli.sunil@gmail.com
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
what is the difference between function modules and subroutines Lockheed-Martin3
I have 10 records in flat file. In that 7th record is error record. I want to update to data base. If i used Call transaction method what about 7 record and what about 8,9,10 records. If i used Session method what happen. Is it updated or stop at 7th record? HCL1
How can u transfer the data from one itab to another without using move & write statements? Satyam1
difference between type and like in detail way  6
what is collective search help? HCL2
What are screen painter and menu painter?  3
CAN WE DEBUG A IDOC? IF YES HOW TO DEBUG IN INBOUND SIDE AND OUTPUT SIDE.  1
what is the difference between user-exit & BADIs?  2
in which event validation is done? CTS2
What is the mandatory event in LDBs.  1
in select _upto N ROWS IF N=0 THEN------------------are rows are selected?  4
what are SPA and GPA parameters?What the Purpose?Examples? under ABAP Memory.  1
what is current version of sap r/3 ? HCL3
what is the difference betn end-of-page and end-of- selection?  3
3. After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?  1
how top handle error in LSMW? Accenture1
What is LDB?  3
Hi all Could u please tell me the answers for following questions, Why we need IDocs...? What is the purpose of IDocs...? Thanks in Advance, Sanjeev.K Keane-India-Ltd4
Difference between interactive and ALV Reports TCS2
Utility of bdc cursor?  1
 
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