Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index ? Types of index and there uses ?
- 3 Answers
- 11896 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / aditya sharma
There are two types of indexes:
1.Primary Index
2.Secondary Index.
While creating a table or in an existing standard table the
key fields are the default primary indexes.
If we require to fetch records from non key fields we need
to provide Secondary Indexes.i.e., we need to explicitly
make non key fields as indexes.
This can be done by clicking on Index and adding the fields
for secondary index.
For Some major standard table SAP has provided secondary
Indexes like
Eg: BSEG table. As BSEG is a cluster table data retreival
using non key fields like Customer/vendor/GL account data
makes the response slower.So SAP has provided standard indexes.
Secondary index tables:
For Customer BSID and BSAD.
For Vendor BSIK and BSAK
For Material BSIM
For GL AccountBSIS
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Search help exit details.
What are match codes? describe?
what precautions or prerequisites do you follow to update a record into database table and how
What is new enhancement framework?
How to add a column to a table control while using alphanumerical layout editor ?
What is img? : sap abap hr
What is meant by stacked list?
Where do you create indexes in abap?
Explain enhancements
What are the different types of laws. What are they?
Explain the advantages of abap query tool?
What is generic buffering?
What is the use of table control in bdc is it same in module pool table control? : abap bdc
Differentiate between abap memory and sap memory?
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
