Interested to Buy Any Domain ? << Click Here >> for more details...
What technical problem you will face if you create many secondary indexes.
- 2 Answers
- 7710 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 kind of deliverables you have on a day to day basis?
Write special commands of list?
What is the difference between bdc_okcode and bdc_cursor? : abap bdc
What is native sql?
What are the different functions used in sap script?
Event handling in oops
Different between Interface and Abstract classes?
What are logical data bases used in hr module? : abap hr
What is sap abap tables?
what is abstract classes
How do you retrieve the data for repetitive structures ? : abap hr
What is the bapi?
What is the tcode to create indexes?
What is the differences between structure and table in the data dictionary in abap?
Explain the difference between function group and function module?
