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..

why you are creating tables ? Already so many Predefined tables are there?

4 Answers   Bristle Cone,

---

Difference between BDC vs Direct Loads?

0 Answers  

---

What is the difference between ABAP and HR ABAP

0 Answers   IBM,

---

1. If I send 5 entries of table from one system to another system, if the only 4 entries there in the target system what I have to do? 2. If I send the customer master IDOC from one SAP system to another system, if one field is missing in target table what is the steps? 3. If I want to access the 4th row 3rd column in the hashed table how to do it? 4. Whether there is any other statement than MODIFY statement to modify the content of internal table?

0 Answers  

---

what are the stpes in ALE?

2 Answers   Satyam,

---

why cluster tables are not buffered

2 Answers  

---

WHICH LANGUAGE IS USED TO WRITE ABAP CODING PART?

1 Answers   TCS,

---

In which table the material master data is stored?

0 Answers  

---

Have you set up a back ground job ? How to create a background job without a variant ?

0 Answers  

---

what is the client on which u have worked? In real time ?

1 Answers  

---

what is table maintainence?

5 Answers   Cap Gemini,

---

how to print only one line item at every page in smart forms in main window .for ex for sales order i will get so many items i need to display only at one page like 1st line at one page and second line at 2nd page .pls answer itttt.

1 Answers   HP,

---