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 will you code in start-of-selection & end-of-selecton & why?

1044


Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.

1116


What work you have done in HR module

1383


How to know if the value entered contains records or not?

1037


Explain the components of selection table?

1144


What are the types of windows in sap script?

1120


Differentiate database index and match code.

1148


What are conversion & interface programs in sap?

1150


singleton class

1407


What is collective search help? : sap abap data dictionary

1024


What is gui status? How to create /edit gui status?

1091


What are ranges?

1052


10) How to get Item Header in Sales Order?

2025


What are number ranges?

1076


Explain the difference between a dialog program and a report?

1039