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 |
7) What is the purpose of main window in SF n Script?
What are the basic components of dialog program?
What are the different elements in layout sets?
Why do we use FOR ALL ENTRIES and what is the pre-requisite
We execute the BDC program in foreground and got list in C drive. If the same program we can execute in back ground what happen?
How data is stored in cluster table?
can we use sub routines in a function module?
what is message type?
What is an abap?
What is an “on request field” statement?
What is Internal Table?
14 Answers Atos Origin, Globel,
what happend if a select statement inside aloop....