What is INDEX Concept. What is Primary Index and Secondary
Index and Difference between Primary & Secondary Index
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 are screen painter and menu painter? : abap hr
How many ways you can create table? : abap data dictionary
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
How do you find the information on the current screen? : abap bdc
What is the difference between get and get late?
Which function module reads the data for particular infotype ? : abap hr
What are the Various Types of internal tables?
Explain what are the events used in interactive reports?
What is static attribute
What are the two different ways of building a match code object?
What is the purpose of at first and at last?
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?
What are internal tables? How do you get the number of lines in an internal table?
How memory management happens for internal tables and work areas in abap?
How to convert the Unit for 'Distance' (The value from one Unit to another).