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 |
How to search a Internal Table Fields?
What is the significance of keyword " H I D E"
please send differences between events
Which configuration we have to make first before we want to start Business Workflow with our SAP R/3
How to get that a secondary index is attached to a select query?
What is a table pool?
What are the user interfaces of interactive lists?
What are the problems in processing batch input sessions? How is batch inputprocess different from processing online?
what are the diff page formats available in SMARTFORMS ?
I created a field and entered the field type, when I double clicked the field type to define the domain; it is asking for an ACCESS KEY, I am not changing any SAP defined tables, working on a user defined table.
when u already have predefined tool LSMW for uploading data....which is more easy and efficient to use and les sprogramming is required..then whats the need to write a program in BDC.... whats the main purpose....?
what is check statement