performance tuning in abap faqs

1. What is performance tuning?
   
2. What are steps you follow to improve the performance of
   a report ?
   
3. what is the role of secondary index in performance?
   
4. what is the role of ST05 in performance tuning?
   
5. what is the role of extended syntax check in
   performance tuning?
   
6. will join conditions in sql queries affect perfomance? how?
   
   
7. will sorted internal tables help in performance?
   
8. will where conditions in a sql query help improve
   performance?
   
9. does select single *.. / select * .. affect performance ?
   how?

Real Time BDC & LSMW faqs

1. What is BDC ?
   
2. What is call transaction method ? what is the
   syntax/procedure?
   
3. What is session method and what is the
   syntax/procedure?
   
4. Difference between call transaction & session method?
   
5. which of these methods can be best used in background
   process?
   
6. What is direct input method?
   
7. How LSMW is advantageous than normal BDC?
   
8. what are the steps in lsmw?
   
9. IN LSMW can you use BAPI, ?
   
10. Can you call a bdc from a report program?
    
11. what is the difference between synchronus &
    asynchronus methods?
    
12. call transaction uses synchronus or synchronus method?
    
13. session method uses synchronus or synchronus method?
    
14. What is bapi?
    
15. how bapi is different from call transaction/session?
    
16. what r the advantages of bapi?
    
17. for uploading master data(ex:customer data) into sap,
    which methods you prefer? call
    transaction/session/lsmw/bapi? why?
    
18. tell any 2 standard bapi function modules used for
    uploading sales order data?
    

Real Time ABAP Internal Tables faqs

1. what is an internal table?
   
2. how many type of internal tables are there?
   
3. what is the difference between hashed & sorted internal
   tables?
   
4. what is the difference between standard and sorted
   internal tables? (in performance wise)
   
5. Difference between internal table and a dictionary table?
   
6. can you create an internal table dynamically?(at run time)
   
7. what is the use of select for all entries in an internal
   table?
   
8. when you are using 2 internal table in program, you have
   decided to use for all entries statement to retrieve data
   but unfortunately there are no records in the first internal
   table. What will be the result? (2nd internal table contains
   records).
   
9. in a loop of an internal table, what is the use of at first &
   at last statements?
   
10. What is the use of at new statement?
    
11. what is the difference between at first & at new
    statements?
    
12. what is a binary search ? and how it is useful in a sorted
    internal table?
    
13. when do you need to create an internal table with header
    line ?and with out a header line?
    
14. what does it mean occurs 0 while creating an internal
    table?
    
15. what will happen if you don't give occurs clause while
    creating an internal table?
    
16. what is the difference between clear, delete & refresh
    with respect to an internal table?