Interested to Buy Any Domain ? << Click Here >> for more details...
What technical problem you will face if you create many secondary indexes.
- 2 Answers
- 7790 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 gui status? How to create /edit gui status?
what is defference between repository and non repository Object?
What is the difference between open_form and close_form?
where do we store all custom programs in SD module?
Performance tuning techniques
What are aggregated objects
What do you mean by transparent tables in sap abap? : abap data dictionary
Explain the data types of internal tables?
What are the parameters used in each function?
Define alv programming in abap?
What is an abap?
Can you define a field without a data element?
Select up to 1 row and select single difference ?
What is pretty printer?
Control Break statements- At new...endat.
