Interested to Buy Any Domain ? << Click Here >> for more details...
What technical problem you will face if you create many secondary indexes.
- 2 Answers
- 7923 Views
- Deloitte, I also Faced
- E-Mail Answers
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 the events we use in dialog programming and explain them?
What are the personnel administration related Infotypes
What are the system fields? Explain?
What will happen when we use single buffered selected?
How you attach search help to data element? : sap abap data dictionary
what is field string ? & where we are using field strings?
What is the difference between retroactive accounting period, earliest retroactive accounting period? : sap abap hr
What functions does a data dictionary perform ?
What are the types of table fields in the sap abap?
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
What functions does a data dictionary perform? : abap data dictionary
Program for Prime numbers and Matrix plz explain me the procedural method with steps
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
Where do you code the hide statement?
