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.

What is alv programming in abap?

0 Answers  

---

how can u write in single program call transaction and session method logic? if u

2 Answers   Enteg Technologies, Wipro,

---

what is use of info records,condition records in material master?

1 Answers  

---

Differentiate between the uline and write: sy-uline statements if any?

0 Answers  

---

how to prepare technical specs? what are the steps used to prepare it?

2 Answers   HCL,

---

What do you do when the system crashes in the middle of batch session?

1 Answers   Vanguard,

---

Explain how do you use structures in the abap programs?

0 Answers  

---

Differentiate between transparent tables, cluster tables and pooled tables

0 Answers  

---

explain any one in briefly what are the books we have to buy to study dont say see the help or abap 21 days if u have any other materials to study please suggest me i am unable to understand

2 Answers  

---

what you use of end-of-selections?

4 Answers  

---

What is the difference between ECC versions and older versions?

1 Answers   Bosch,

---

what is the way to find out user exits?

4 Answers   Accenture,

---