how many indexes can be created for a table?
- 7 Answers
- 12808 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 can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What are the different methods of passing data?
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
What is a type group?
What is the significance of delivery class? : abap data dictionary
Have you set up a back ground job ? How to create a background job without a variant ?
What is sap abap data classes?
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'
What is the difference between Exit and Stop?
Why do we use Abstract classes give an example from your project?
What are the uses of interactive reporting?
What is meant by authorization? : sap abap hr
A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary
What is an update task?
