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

A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization

1032


Is main window mandatory in smartforms?

1180


How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?

1062


What are the functional areas, user groups? How does abap query work in relation to these?

1049


What is structure?

1064


What is the difference between open_form and close_form?

1091


What is append search help? : sap abap data dictionary

1195


Explain the difference between a dialog program and a report?

995


What is the difference between scrolling a table horizontally and vertically?

1066


What is the difference between collect and sum?

1184


What are the different function modules used in sapscript?

1032


We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???

2102


Polymorphism real time scenario

1500


Difference between sy-tabix and sy-index? Where it is used?

938


If your project is support project ? when is your implementation has completed ?

2123