Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is your approach for writing a bdc program? : abap bdc

1086


What are the steps to be followed to set lockobjects? : sap abap data dictionary

1156


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

1145


How to insert a line into abap internal tables?

1131


what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?

2490


How is collect statement different from append?

1083


What are datasets in abap?

1213


WHAT ARE THE INPUT PARAMETERS TO BE PASSED FOR THE BAPIS 'BAPI_CUSTMATINFO_GETDETAILM' AND 'BAPI_CUSTMATINFO_GETLIST'

2307


****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

2218


Can you assign a matchcode object to a parameter? If so how?

1095


What are the 2 other types of views, which are not allowed in release 3.0?

1167


What is a match code? : abap data dictionary

1338


What does the insert statement in extract datasets do?

1127


Why is pretty printer user in abap?

1328


How do you process errors in session method ? : abap bdc

1189