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
To how many tables can an append structure be assigned. : abap data dictionary
Explain what is the purpose of sap script?
List some of the many different ways that the sap standard functionality can be changed by a customer?
wht is the diff. b/n initialization and lotus of event
What is table attribute? : abap data dictionary
What are the steps to be followed to set lockobjects? : sap abap data dictionary
SAP query how to use end users?
How is conversion of data types done between abap/4 & external level?
How to add a column to a table control while using alphanumerical layout editor ?
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
What is a help view? : abap data dictionary
What is the logo in sap script?
Explain what is the significance of hide?
How do you execute the payroll
Which function modules can be used to transfer the data using bdc programming? : abap bdc