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

Can we create field without data element? If yes, how?

0 Answers  

---

What are the types of table fields in the sap abap?

0 Answers  

---

12) How to add Text Modules in SMARTFORMS?

1 Answers   Mascon,

---

what is the difference between hashed & sorted internal tables?

0 Answers  

---

What is the difference between At selection screen and At selection screen on output?

2 Answers   IBM,

---

please clear this what is the diff b/w select single * and select up to 1 row?

5 Answers  

---

what are the steps in oops alv reports?

1 Answers   IBM,

---

What is an evaluation path? : sap abap hr

0 Answers  

---

How to Split one delivery into many ( Step by Step)?

2 Answers   Accenture,

---

What are control tables?

0 Answers  

---

how to print amount in words in alv ?? will the function module spell_amount work ??

1 Answers   TCS,

---

how to change output option of table control?

1 Answers  

---