What is an index ? Types of index and there uses ?
- 3 Answers
- 10619 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
Explain the difference between tables and structures?
How you attach search help to data element? : sap abap data dictionary
what is friend class
What is the function module to popup contents in the internal table?
if u take one worst program,in this program user write the logic is session method.in that program user can get some errors ,that errors we will see in call transaction method,how it is possible.?
What is the disadvantage of a call by reference? : abap modularization
What are the different kinds of lock modes?
What are the dynamic actions and how to configure it? : sap abap hr
Difference between Field groups and internal tables?
What is a 'z' report?
What are the different software packets available in the market? : sap abap hr
How can we decide weather we can enhance the standard infotype or not ? : abap hr
what is bapi,badi,bdc,ale idocs?
What is the different between template and a table?
On which event we can validate the input fields in module programs?
