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 different functions used in sap script? What are the parameters used in each function?

0 Answers  

---

Why we do Version comparison?

2 Answers   IBM,

---

how to upload logo in the smart forms

2 Answers   Wipro,

---

1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?

0 Answers   Bristle Cone,

---

What are the requirements a dialog program must fulfill?

0 Answers  

---

What is a batch input session?

3 Answers  

---

What is LDB?

4 Answers  

---

what is the use of free and refresh?

11 Answers   Accenture, IBM,

---

A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary

0 Answers  

---

why SAP scripts are client dependent and smart forms are not?

5 Answers   KPIT,

---

Events in Interactive reporting?

3 Answers   TCS,

---

Between select .........endselect write one statement executes the cursor goes to dump analysis?what is the statement ?

1 Answers  

---