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
What are multiple use BADIS?
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
Can you show multiple alvs on a single screen?
What is interactive reporting?
What is the procedure you followed to upload the data?
please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?
What was the requirement of IDoc in your project? How it was working?
I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.
What is the function of a data element?
How to set an Enhancement point for a custom report?
What are the commands used for interactive reports?
Does sap handle multiple languages?
How is conversion of data types done between abap/4 & db layer?
Can we specify the next screen number with a variable?
What are the functional areas, user groups? How does abap query work in relation to these?