Answer / uma mb

Index on a table or indexing a table can speed up record
access in the table. Index is a copy of the database table
but in its reduced form (only certain key fields exist in
the index along with a pointer)The data stored in the index
is in a sorted order of the primary key in a primary index
and secondary (alternate) key in a secondary index.

Primary index is automatically created when the table is
activated after creation. A secondary index is created
manually (by ABAP developer or admin person as per dictates
of the workshop) if it is felt that a large table is
accessed too many times based on some field (like employee
name in the EMPLOYEE MASTER) or fields that do not
participate in the primary key formation.

It is possible to specifiy while creating secondary index if
this index should be created on table activation. And then
these secondary indexes can give a performance gain only on
certain database systems and therefore these database
systems can be specified while creating the secondary index
so that such an index is created only on those specific
database systems. Also user created secondary indexes must
begin with Y or Z and can have three character position
names. Must not use 0 (zero) as this is reserved by SAP for
primary index.

When will the current screen processing terminates?

0 Answers  

---

Difference between Occurs0,occurs10 and occurs100?

4 Answers   HCL,

---

What in script controlling? what are the events in maintenance view:

1 Answers   Accenture,

---

Explain about interactive report?

0 Answers  

---

How to create secondary index ?

2 Answers  

---

What is the Use of LDB PNPCE in ABAP HR? what is NODES statement? I think we have to use GET PERAS event while using PNPCE. Can we use the same using PNP LDB? If yes,how? please give me some example to demonstrate PNPCE?

1 Answers  

---

Difference between SY-CPROG and SY-REPID? Plz give me the answer,its urgent!

6 Answers   Accenture,

---

tell me about status codes?

2 Answers   Accenture, Satyam,

---

Of the two call transaction and session method, which is faster?

0 Answers  

---

What is field catalog?

2 Answers   FutureSoft,

---

I have two applications one is 'cov letter' and Purchase order.how will you process these forms in your driver program and tell me the sequence of the FM?

1 Answers  

---

How do you call a transaction from a report ?

3 Answers  

---