Interested to Buy Any Domain ? << Click Here >> for more details...
how many indexes can be created for a table?
- 7 Answers
- 14799 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / niranj
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 ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is value table?
What is pretty printer?
What is a function group? : abap modularization
What are the different types of the sap abap data dictionary objects?
2)In production what is the user exit?
Difference between call by value and call by reference? : abap data dictionary
What is a type group?
How can I get ascii value of any letter? Is there any function?
What are indexes? : abap hr
What is an abap?
Explain the concept of clusters in payroll
Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?
How can I make a differentiation between dependent and independent data? : abap hr
Update types in Call transaction method. What is the difference?
Explain the call transaction method? : abap bdc
