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


Please Help Members By Posting Answers For Below Questions

What are the different types joins?

804


Define alv programming in abap?

986


A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary

943


Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?

844


Can we control the sequence in which multiple implementations of a multiple use BADI are called? If yes, how?

1138


What does the insert statement in extract datasets do? : abap modularization

819


What is the difference between Exit and Stop?

860


Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?

795


Explain the components of selection table?

850


What is the difference between data elements and domains?

841


What are conversion & interface programs in sap?

852


What is the difference between a pool table and a transparent table?

770


What is meant by slab? How is indian slab and us slab? : sap abap hr

838


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

1855


What is an rdbms?

823