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.

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

What are the difference between call screen and leave screen?

0 Answers  

---

How to find the return code of a statement in abap programs?

0 Answers  

---

What is the process of project flow n sap?In context to project flow what are the role of an abapper?

4 Answers   Exa AG, TCS, Wipro,

---

do 4 times. sy-tabix,sy-index. end do. what is the output ?

3 Answers   TCS,

---

What is SAPscript and layout set?

1 Answers  

---

---

What is gui status? How to create /edit gui status?

0 Answers  

---

what is the function module to read the standard text?

4 Answers  

---

Can we use on change of between select and endselect?

0 Answers  

---

By using which FM we can upload data into Infotype

3 Answers  

---

will sorted internal tables help in performance?

1 Answers  

---

What happens if a function module runs in an update task? : abap modularization

0 Answers  

---

what is the field to be used in field catalog of an ALV report to hide the relevant column in the list?

1 Answers  

---