What is an index ? Types of index and there uses ?

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


Please Help Members By Posting Answers For Below Questions

How to select valid lines for secondary list?

610


Double click function on the lists, identifying the line selected by the user on the list?

630


Rp_provide_from_last contains how many parameters ? : abap hr

880


Can you set up background processing using call transaction?

596


How do you find the information on the current screen?

601






What are conditional chain statement?

751


How many types of size categories and data classes are there? : abap data dictionary

611


What are the different types of locks? : abap data dictionary

635


What are the differences between interactive and drill down reports?

548


What is meant by exclusive, not cumulative lock? : sap abap data dictionary

590


What is step-loop? Explain all the steps?

544


How to Raise a Particular Ticket in Realtime ?

1638


how 2 create the normal form by using functional module

2138


What is the meaning of sap r/3?

607


Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button

1772