What technical problem you will face if you create many secondary indexes.
Answers were Sorted based on User's Feedback
Answer / pratap
Secondary indexes should contain columns that you use frequently in a selection, and that are as highly selective as possible.
Only 9 Indexes allowed
from efficiency point of view only 5 can be created because
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 ? | 9 Yes | 0 No |
Answer / sriharsha
Try to research about db hints ,
this will table to use which secondary index as you should already know which index to use for your query.
problem is all DB's handle hints differenty, some dont bother about your hint
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the difference between cluster tables and pool table?
If there are errors in BDC Call Transaction method, once the correction of errors is made how will you run this as Session method ?
Explain about No intervals, no extension in select options.
What are the list of screen elements?
Define subtype ? : abap hr
What are Call Transaction Modes?
Why do we use abstract class
Explain what is an rdbms?
when we use the SELECT statement along with FOR ALL ENTRIES then what type of validations we have do before executing this statement
2 Answers Cap Gemini, Mphasis, TCS,
what is the difference b/w database and data dictionary?
What is up-casting and down casting? with example
Can we make use of flow logic control key words in abap/4 and vice-versa?