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.

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?

2 Answers   Deloitte,

---

What are the page windows?

0 Answers  

---

the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....

0 Answers  

---

In Data Types.,Packed p?

2 Answers   Atos Origin,

---

What are labels in scripts..? why are they not accpeted in smartforms..?

2 Answers   IBM,

---

give examples of pool,cluster tables

5 Answers   SAP Labs, WDC,

---

how to convert sapscript to email.....

1 Answers  

---

Do you use select statement in loop end loop, how will be the performance? To improve the performance?

2 Answers  

---

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

0 Answers  

---

Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

0 Answers  

---

what is the diffrence between driver program and print program in sap script

10 Answers   Accenture, Satyam,

---

can i use table key and key in an internal table and explain the functionalities of each one and what functionality does it give if both are used for same internal table

0 Answers   Wipro,

---