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
What will you code in start-of-selection & end-of-selecton & why?
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.
What work you have done in HR module
How to know if the value entered contains records or not?
Explain the components of selection table?
What are the types of windows in sap script?
Differentiate database index and match code.
What are conversion & interface programs in sap?
singleton class
What is collective search help? : sap abap data dictionary
What is gui status? How to create /edit gui status?
What are ranges?
10) How to get Item Header in Sales Order?
What are number ranges?
Explain the difference between a dialog program and a report?