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

Why cant we use Normal function module for data transfer?

2147


List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr

888


What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

1100


What are the tcodes for performance tuning?

1408


Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul

3644


what is difference between user exit, customer exit and badi?

5090


How many lists can a program can produce?

1007


Difference between domain and data element? What are aggregate object?

1075


What is the use of abap data dictionary? : abap data dictionary

1000


What are the different types of abap reports in sap?

1274


Which transaction code can I use to analyze the performance of abap program?

979


What is the transaction for recording bdc ? : abap bdc

1008


What are the components of sapscript?

1017


When was the sap abap being created?

1078


How can we determine a vendor is Bloc/Unblock from the table LFA1?

2038