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
Why cant we use Normal function module for data transfer?
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc
What are the tcodes for performance tuning?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
what is difference between user exit, customer exit and badi?
How many lists can a program can produce?
Difference between domain and data element? What are aggregate object?
What is the use of abap data dictionary? : abap data dictionary
What are the different types of abap reports in sap?
Which transaction code can I use to analyze the performance of abap program?
What is the transaction for recording bdc ? : abap bdc
What are the components of sapscript?
When was the sap abap being created?
How can we determine a vendor is Bloc/Unblock from the table LFA1?