What is INDEX Concept. What is Primary Index and Secondary
Index and Difference between Primary & Secondary Index
- 1 Answers
- 26458 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
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?
What is a type group?
What is macro? : abap hr
Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?
What are the screen elements.
How do you work with semi colon se[arated files in BDC ?
What is the last entry in all bdc tables? : abap bdc
What is a 'z' report?
What are the domains and data elements?
What is the max no of match code id’s that can be defined for one match code object?
Proxy Programming with ABAP - How to develop the Proxy identification through programming
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
Name the abap/4 modularization techniques? : abap modularization
What is update task
What is a table cluster? : abap data dictionary
