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 |
What is the testing tool in ale........
WHAT IS THE ROLE OF WORK BENCH ORGANIZER?
How do you process errors in session method ? : abap bdc
What is an abap dictionary? : abap data dictionary
What is is a match code? : abap data dictionary
We have got some values for Field F1 say 1,2,3,4 and F2 say 10,10,10,10.Now can you tell me what would be the output for F1 if we use At End Of event?and what would be the output for F2 if we use At Last event?Also i want to know what is the difference between Total calculation for At end event and grand total for At last event???
What are field symbols and field groups.?
what is use of info records,condition records in material master?
What is meant by enhancements?
in interactive reports i can use hide field for secondary list out put in ALVs for secondary list as a out put which field r u using?in interictive list ican use HIDE in ALVs which field r u using?
We have 100 records in table how to fetch 10 th record?
What is the Tcode for System Dump?