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 Bapi?what is the functionality of Bapi?why we go for Bapi?
How do you define an internal using types?
How do you differentiate tax for different countries? : sap abap hr
what is advantages and disadvantages in call by value and call by reference
10 Answers College School Exams Tests, Wipro,
what is the difference between user exit and customer exit? what is ment by cusomer exit?and what is the difference between user exit and badi?
what is the use of help view?how can we create search help for a field?in how many ways we can give search help?
Hi folks , this is venkat ,I am looking for SAP EDI training if you have any idea please mail me contact details vekat.
explain the script component in script?
What is database view ? : sap abap data dictionary
Which objects are independent transport objects? : abap data dictionary
Can a transparent table exist in data dictionary but not in the data base physically?
What is the function module to popup contents in the internal table?