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 is the difference between select single and select upto 1 rows?

5 Answers   Genpact,

---

What is sap locking?

0 Answers  

---

what is the difference between user exit and customer exit? what is ment by cusomer exit?and what is the difference between user exit and badi?

2 Answers  

---

What is the Difference between Transparant Tables , Pooled & cluster Tables?

1 Answers   Patni, Satyam, Siemens,

---

Explain the Importance of pa20? : abap hr

0 Answers  

---

Module Pool Programming: Events and Table Control handling.

0 Answers   Infosys,

---

what is the difference between function modules and subroutines

7 Answers   Lockheed Martin,

---

Explain the disadvantages of different types of bdc's?

0 Answers  

---

what are steps of smart form. pls complete step mail me on :zaheer_guts@yahoo.co.in

2 Answers   Cap Gemini,

---

What are the differences between interactive and drill down reports?

0 Answers  

---

Can we use same DATA ELEMENT for more than one field?

7 Answers   HCL, Unilogic Software,

---

What are the attributes of a field that can be activated or deactivated during runtime?

0 Answers  

---