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
Explain sap abap 3-tier architecture?
What are the arithmetic operators in the sap abap?
how to see the tables of 200 in client 100?
What is a logical database?
How to write a bdc – how do you go about it?
How did you test the form you developed? How did you taken print?
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul
what is abstract classes
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
What is the bapi?
What is the use of table maintenance allowed?
Mention what is alv programming in abap?
What is open sql vs native sql ?
How many types of tables exist and what are they in data dictionary?
What is filter dependent BADI?