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
A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization
Is main window mandatory in smartforms?
How can an internal table with header line and one without header line bedistinguished when passed to a subroutine?
What are the functional areas, user groups? How does abap query work in relation to these?
What is structure?
What is the difference between open_form and close_form?
What is append search help? : sap abap data dictionary
Explain the difference between a dialog program and a report?
What is the difference between scrolling a table horizontally and vertically?
What is the difference between collect and sum?
What are the different function modules used in sapscript?
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???
Polymorphism real time scenario
Difference between sy-tabix and sy-index? Where it is used?
If your project is support project ? when is your implementation has completed ?