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
- 27656 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 is SAP Data conversion ?
What is the tcode to create indexes?
What are conditional chain statement?
Why grouping of fields is required? What is the max no of modification groups for each field?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
What is the different between abap and ooabap? Why do we use ooabap?
What is structure?
Explain enhancements
What is a view in sap? : abap data dictionary
What is the difference between Exit and Stop?
What application areas are you comfortable in?
What are the requirements a dialog program must fulfill?
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why?
How do you get the number of lines in an internal table?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
