Answer / rohit

If you cannot use the primary index to determine the result
set because, for example, none of the fields primary index
occur in the WHERE or HAVING clause, the system searches
through the entire table (full table scan). For this case,
you can create secondary indexes, which can restrict the
number of table entries searched to form the result set.

You should only create secondary indexes, for database
tables from which you mainly read, since indexes have to be
updated each time the database table is changed. secondary
indexes should contain columns that you use frequently in a
selection, and that are as highly selective as possible to
improve performance..

If i double click on any sales order no it sud take me to the transaction how?

3 Answers  

---

In one of our zflash against collections report is not matching with the actual collections i.e invoice valuse of 200000 and payment had received for entire invoice and as per accounts of the particular customer this invoice is cleared but when we had tken z flash for collections which had developed my ABAP tem it's not matching.it's happened for many invoices how to get right report as per the payment details?

1 Answers  

---

in views..date base view can be used instead of join state ment in a program..it is one of reusable technique..is it correct???

2 Answers  

---

WHAT IS TCODE TO CREATE NEW MESSAGE TYPE?

2 Answers   Sony,

---

Batch Monitor -- Transaction Code?

3 Answers   Cap Gemini,

---

Does every abap/4 have a modular structure? : abap modularization

0 Answers  

---

What is an Unpack command?

0 Answers  

---

i had to write the code in such a way that duplicate entries should not entered in sap data base

2 Answers   IBM,

---

How to call A report from other report widout using include program..??

3 Answers   IBM,

---

5. What is the difference between report and script?

2 Answers  

---

How to get the no of records using select statement?

4 Answers  

---

what is standard , sorted and hash in abap ?

2 Answers   Novellus,

---