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
Describe the data classes?
What is a table pool? : abap data dictionary
What is an internal table?
What is the meaning of abap/4 editor integrated with abap/4 data dictionary?
What are the value tables?
What is tcode se16? For what is it used.
Explain read dataset in sap abap?
Cds views
What is direct input method ?
What is a multiple line field? : abap bdc
Did you use buffering?
What is primary index?
Can you delete data element, which is being used by table fields. : abap data dictionary
What is an rdbms?
In which table the material master data is stored?