What technical problem you will face if you create many secondary indexes.
Answer Posted / pratap
Secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible.
Only 9 Indexes allowed
from efficiency point of view only 5 can be created because
You should not create more than five indexes for any one
table because:
Whenever you change table fields that occur in the index,the index itself is also updated. The amount of data increases. The optimizer has too many chances to make mistakes by using the 'wrong' index.
If you are using more than one index for a database table,ensure that they do not overlap.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How is conversion of data types done between abap/4 & external level?
What are the user interfaces of interactive lists?
What is the structure of bdcmsgcoll? : abap bdc
What is the difference between a substructure and an append structure?
Name the special commands of list?
What is a batch input session? : abap hr
What is the difference between field-group header and other field groups?
Which function module would you use to check the user’s authorization to access files before opening a file?
What is an abap dictionary? : abap data dictionary
What is the significance of the screen number ‘0’?
Explain the difference between get and get late?
1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?
Define abap/4 layer? : abap data dictionary
Differentiate between ooabap and abap?
What is internal payroll process? : sap abap hr