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 happens Update command is used without where clause ?
In data element how many domains were defined
What is the major difference between pool tables and transparent tables?
What will you code in start-of-selection & end-of-selecton & why?
what is the output of given code? data : f1 type i, f2 type i. write : / f1, f2. do 2 times. perform addfld. enddo. write : / f1, f2. form addfld. data : f1 type i, f2 type i. add 1 to f1. add 1 to f2. write : / f1 , f2. endform. int : f1 , f2.
what data types allows length specification ?
why sapscripts are client dependent and smartforms are cliet independent,plz give me a brief explanation,thank u.
What is elementary search help? : sap abap data dictionary
1.What is the difference between append structure and include structure. 2. what is the logging of technical setting while creating db table.
5 Answers Accenture, NTT Data,
Do you use select statement in loop end loop, how will be the performance? To improve the performance?
What are the control break events in abap? : abap data dictionary
Explain how to write a bdc - how do you go about it?