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 |
Type groups?
What is the difference between At selection screen and At selection screen on output?
what is difference bt ABAP MEMORY AND SAPMEMORY
wat are the user exits for the po reports?
what objects can be generated by the batch input recorder?
What is the difference between bdc_open_group and bdc_open_dataset. : abap bdc
What is the Difference between At Line selection and At user-command?
How to debug a smartform using SMARTFORM_TRACE....and how to see its results
what do u mean by occurs 0
How can we access the correction and transport system?
What is the use of at new statement ?
How to find Buffered or not?
2 Answers Cap Gemini, Unilogic Software, Visa Steel,