Interested to Buy Any Domain ? << Click Here >> for more details...
What technical problem you will face if you create many secondary indexes.
- 2 Answers
- 7839 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 is the difference between open_form and close_form?
what are the important fields while preparing sales order,inquiry?
What is macro? : abap hr
What two statements would be used to exchange data between programs using abap memory?
How can you display frames (horizontal and vertical lines) in lists?
What are the different types of views in sap? : abap data dictionary
How to set an Enhancement point for a custom report?
What are the dynapro keywords?
Why we are using Macros instead of Function Modules
what is sap scriptview ?
How do I find the output type of a table or a program?
How can we access the correction and transport system?
what is leave to TRANSACTION?
Are you familiar with all steps for setting up a workflow?
What is cts and what do you know about it? : abap hr
