Interested to Buy Any Domain ? << Click Here >> for more details...
What is INDEX Concept. What is Primary Index and Secondary
Index and Difference between Primary & Secondary Index
- 1 Answers
- 27520 Views
- Satyam, Vistex, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 28 Yes | 5 No |
Post New Answer View All Answers
What will you code in start-of-selection & end-of-selection ?
What are the advantages/ dis-advantages of logical databases?
how can you display data say "your name"in sap script without print program or driver program??
In a loop of an internal table, what is the use of at first & at last statements?
What are the differences between session method and call transaction method? : abap bdc
Explain the different types of screen keywords?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
What is the difference between internal tables and extract datasets? : abap modularization
What are the two levels in defining a match code? : abap data dictionary
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?
What is the use of dequeue function module? : sap abap data dictionary
What is its? : abap hr
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
What is view? Explain the different types of view?
