Interested to Buy Any Domain ? << Click Here >> for more details...
how many indexes can be created for a table?
- 7 Answers
- 15000 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
How is conversion of data types done between abap/4 & db layer? : abap data dictionary
What is the difference between commit-work and rollback-work tasks?
What are the layers of data description in r/3? : abap data dictionary
What is cts and what do you know about it? : abap hr
Can a domain, assigned to a data element be changed?
What is the difference between synchronous and asynchronous update? : abap bdc
How the transaction that are programmed by the user can be protected?
What are the different types of internal table?
What is partner selection?
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
What is the difference between upload and ws_upload ? : abap bdc
How to create any functions?
What is the maximum number of structures that can be included in a table or structure
What is match code? : sap abap hr
How many main windows will be there in a page window?
