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 tcode se16? For what is it used.

0 Answers  

---

how to see the tables of 200 in client 100?

0 Answers  

---

What actually happens in real-time recruitment? : sap abap hr

0 Answers  

---

A Program calls a Function module. what happens to the ABAP memory allocation used by the functional module when the functional module is completed?

2 Answers  

---

What are the advantages of logical databases : abap hr

0 Answers  

---

What are the aggregate objects in the dictionary? : abap data dictionary

0 Answers  

---

i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status

0 Answers  

---

Have you printed any report?

0 Answers   TCS,

---

what is single screen maintainence?

1 Answers  

---

what is T.Code to write ABAP program?

9 Answers   FutureSoft, SAP Labs,

---

what will happen if you don't give occurs clause while creating an internal table?

4 Answers  

---

what is the difference between user-exit & customer-exit?

4 Answers  

---