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 is its?
How does the system handle roll areas for external program components?
Did you create primary index?
How can we handle table control in bdc? : abap bdc
Have you processed BDCs ?
what is difference between user exit, customer exit and badi?
What are the different types of abap/4 programs?
What are the data types of internal tables?
What are the two levels in defining a match code? : abap data dictionary
What are base tables of an aggregate object? : abap data dictionary
Why is pretty printer user in abap?
Explain the function module in bdc?
Where do you find info on new developments in SAP?
What is the use of table maintenance allowed?
what is difference between (internal table types)standard table and sorted table in sap abap....