Interested to Buy Any Domain ? << Click Here >> for more details...
how many indexes can be created for a table?
- 7 Answers
- 15320 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
Explain the data types of internal tables?
I just wanted to know that when I am recruiting somebody, I am generating his personal no also. Then I want to give him training also. Now I just want to create 2 scenarios to clear my doubts? : sap abap hr
Explain how do you use structures in the abap programs?
What are match codes? describe?
PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'
How can you access the function code from menu painter?
How many types of tables exists and what are they in data dictionary?
What is dialog module?
How to display if the value entered contains records or not?
What are the personnel administration related infotypes? : abap hr
What are the difference between call screen and leave screen?
What is netweaver???what is the relationship with ABAP?
What is meant by slab? How is indian slab and us slab? : sap abap hr
What is the difference between a substructure and an append structure? : abap data dictionary
How to find Kernal badi ?
