how many indexes can be created for a table?
- 7 Answers
- 13373 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 bdc? : abap bdc
I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.
Explain lsmw?
How do you Export a session ?
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.
What are the functional areas?
What are plan versions used for? : sap abap hr
What is primary index?
What is a 'z' report?
What are pooled tables? : abap data dictionary
What are the personnel administration related infotypes? : abap hr
What is the table & field to identify the no of items (bottles) stored in one case?
Define external layer?
What is asap methodology? : sap abap hr
