With the use of secondary index we can make a program run
faster but we are advised not to use secondary index why is
that so??
Answer Posted / anju
B'coz secondary index is just like a copy of data base
table reduced to specific fields.So,insertion and updation
in database become slow after creation of secondary index
where as read from table become fast.
This is b'coz additional indexes can also place a load on
the system since they must be adjusted each time the table
contents change. Each additional index therefore slows down
the insertion of records in the table
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
What is your approach for writing a bdc program? : abap bdc
What are the steps to be followed to set lockobjects? : sap abap data dictionary
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
How to insert a line into abap internal tables?
what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?
How is collect statement different from append?
What are datasets in abap?
WHAT ARE THE INPUT PARAMETERS TO BE PASSED FOR THE BAPIS 'BAPI_CUSTMATINFO_GETDETAILM' AND 'BAPI_CUSTMATINFO_GETLIST'
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
Can you assign a matchcode object to a parameter? If so how?
What are the 2 other types of views, which are not allowed in release 3.0?
What is a match code? : abap data dictionary
What does the insert statement in extract datasets do?
Why is pretty printer user in abap?
How do you process errors in session method ? : abap bdc