Interested to Buy Any Domain ? << Click Here >> for more details...
how many indexes can be created for a table?
- 7 Answers
- 14889 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
Why is pretty printer user in abap?
What is a table pool?
8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?
What is locking? : abap data dictionary
Can we use flow logic control key words in abap/4 and vice-verse?
How do we handle multiple line items in BDC's.
Cds views
What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
What is lock objects? : sap abap data dictionary
What is pnp-sw-found ? : abap hr
Explain the advantages and disadvantages of abap query tool?
Does the external program run in the same sap luw as the caller, or in a separate one?
Difference between Insert, Update and Modify?
What does hide statement do?
What are the aggregate objects in the dictionary? : abap data dictionary
