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 are the steps to execute session method?

1055


what is the exact code that shoud be implimented in sap note

2488


How do you delete duplicate records from internal table?

1196


How to use messages in lists?

1063


Explain the difference between a pool table and a transparent table?

1011


What is an evaluation path? : sap abap hr

1056


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

1111


What is a transport?

1113


Define subtype ? : abap hr

1024


Explain get cursor field?

1194


What is the difference between leave transaction and call transaction?

1060


Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr

958


What is off cycle payroll run

2259


Difference between domain and data element? What are aggregate object?

1118


What is get cursor field?

1431