how many indexes can be created for a table?
Answers were Sorted based on User's Feedback
Answer / sharath
1 Primary Index and 21 secondary Index totally 22 Index we can create in ECC6.00.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gopi paruchuri
16 Primary indexes and 9 secondary indexes
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / damodar reddy
For any table we can create 1 primary index and maximum of
15 secondary indexes.
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / 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 |
Can we create Secondary Indexes for the Views
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary
what is the difference between interface and global diffinations in smartforms?
What are select options and what is the diff from parameters?
have you used performance tunig?what major steps will you use for those
Badi concepts
What is the use of the raising exception?
How to same internal table in same functional module?
I have two internal tables itab1 and itab2 and I had move the content of the itab1 to itab2 and then itab1 had to deleted
Which method of BDC’s would u apply ? Session or call transaction ? why ? Which is more good ? Its advantages ?
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
what is the table to find change pointer status?