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

To how many tables can an append structure be assigned. : abap data dictionary

1043


Explain what is the purpose of sap script?

1073


List some of the many different ways that the sap standard functionality can be changed by a customer?

912


wht is the diff. b/n initialization and lotus of event

1889


What is table attribute? : abap data dictionary

1006


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

1049


SAP query how to use end users?

2155


How is conversion of data types done between abap/4 & external level?

983


How to add a column to a table control while using alphanumerical layout editor ?

2352


Why do we declare a method of a class final? What can be the purpose? Give a scenario.

1366


What is a help view? : abap data dictionary

1049


What is the logo in sap script?

1012


Explain what is the significance of hide?

1021


How do you execute the payroll

2280


Which function modules can be used to transfer the data using bdc programming? : abap bdc

1106