What is an index ? Types of index and there uses ?
- 3 Answers
- 11292 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
what is difference between user exit, customer exit and badi?
What is meant by authorization? Did you ever work on it? : sap abap hr
What are the functional areas? User groups?
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
How to display if the value entered contains records or not?
What is the difference between synchronous and asynchronous update?
In the MM module for finding out the standard cost what is the view one has to look at?
In se11 -->Tech. settings --> Data class. If I save table as Mater data OR Transaction data, what effect will it has for 'Storage' in Database after activation. or In Database how it will store in both the cases.
How can you display frames (horizontal and vertical lines) in lists?
Explain what is the difference between primary key and unique key?
What are the page windows? How many main windows will be there in a page window?
What are matchcodes?
In which time constraint does the infotype records depend on the subtype ? : abap hr
Where are you used type casting?
What are the types of subroutines? : abap modularization
