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

can u add a new view to the existing view?

2 Answers   Bristle Cone, Cap Gemini, HP, Satyam, Wipro,

---

What are the update types possible? : abap data dictionary

0 Answers  

---

What are hashed tables?

0 Answers   Infosys,

---

Some one is running a program in Foreground which has to be run in Back ground. How you are going to instruct to do in Back ground?

1 Answers  

---

Internal table itab contains some records. If the code is like this : LOOP AT ITAB. APPEND ITAB. ENDLOOP. What ill be the result??

3 Answers   Accenture,

---

How do you document abap/4 programs? Do you use program documentation menu option?

0 Answers  

---

Tcode for SNIP?

3 Answers   Bristle Cone,

---

Mention the various databases integrities?

0 Answers  

---

Does SAP handle multiple currencies? Multiple languages?

1 Answers  

---

1) What is the difference between TYPE and LIKE ?

3 Answers  

---

What is the definition of modification in an sap system and how do they impact an upgrade?

0 Answers  

---

what is mean by table control, where it is used? why it is use?

1 Answers   IBM,

---