Interested to Buy Any Domain ? << Click Here >> for more details...
how many indexes can be created for a table?
- 7 Answers
- 15094 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is web dynpro for abap?
Explain data dictionary in abap?
Define database layer? : abap data dictionary
What is buffering in abap?
what is defference between repository and non repository Object?
Explain the data types of internal tables?
What is repository info. Systems?
Of the two call transaction and session method, which is faster?
When the get cursor command used in interactive lists?
What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary
Why do we need enhancements?
How would you suppress the display of a parameter on the selection screen?
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
What is the maximum number of structures that can be included in a table or structure : abap data dictionary
Differentiate between transparent tables, cluster tables and pooled tables
