how many indexes can be created for a table?
- 7 Answers
- 12772 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 append search help? : sap abap data dictionary
How do you document ABAP programs? Do you use program documentation menu option?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
Sal abap on hana interview
What are the uses of table pool or table cluster.
Is it possible to pass data to and from include programs explicitly? : abap modularization
What are the modes in which any update tasks work?
What are the different types of parameters?
What are Tickets in Realtime ?
What is the difference between a substructure and an append structure?
What is the difference between Check and Continue?
What is the difference between field-group header and other field groups?
What are the personnel administration related infotypes? : abap hr
can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.
