Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is the difference between a pool table and a transparent table and how they are stored at the database level?

1064


Fallback class

2246


Explain the client concept of sap.

1032


What is dialog module?

1078


Explain pai and pbo.

1234


Do we create table fields with out data elements and domains?

1098


What are the different functions used in sap script? What are the parameters used in each function?

1172


Define external layer?

1191


What is client in the sap system? : sap abap hr

1085


What is sap script? Describe its components.

1082


What two statements are required in an abap program to output an icon using a write statement?

990


can anyone do BDC or BAPI for F-02 and F-04 transactions.If it LSMW also.Kindly let me know.

3728


How to debug rfc function module?

1282


What are the page windows?

1009


How do you validate the selection criteria of a report? And how do you display initial

1110