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

I have 2 fields like customer and name having 20 records on basic list. when i select 5 records randomly, i want to get the address of particular customer selected in secondary list

1 Answers  

---

6. what are the differences between scripts & smart forms?

2 Answers  

---

Explain buffering concept usage?

0 Answers  

---

in what application server the business logic is developed/deployed?

2 Answers   Zydus Cadila,

---

How to display if the value entered contains records or not?

0 Answers  

---

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

1 Answers  

---

What are local objects? : abap data dictionary

0 Answers  

---

why scripts are client dependent and smart forms are client independent.?

6 Answers   Bosch, Cap Gemini,

---

Difference between transparent tables and pooled tables? : abap hr

0 Answers  

---

Work most on which module: name a few tables?

0 Answers  

---

Any once please tell me some interview questions regarding Smartforms?

3 Answers  

---

Why do we use CALL FUNCTION ..IN BACKGROUND TASK and CALL FUNCTION ...STARTING NEW TASK? What is the difference?

2 Answers   HCL,

---