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 exception class and test class. How to use it?
What is meant by slab? How is indian slab and us slab? : sap abap hr
Is main window mandatory in smartforms?
What are the differences between sap memory and abap memory?
what is the exact code that shoud be implimented in sap note
What are the differences between primary and secondary indexes?
What is system-land-scape of your project?
How can you access the function code from menu painter?
What are the different buffering methods?
Difference between sap script and report?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
Name the function module used to convert logical file names to physical file names in abap/4 programs?
Different between Interface and Abstract classes?
What is hotspot?