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...

difference between primary index and secondary index.when we
use secondary index in reports?

Answer Posted / sivaramakrishna

when we want to get the details based on a field in select
statement we should use always primary key fields to
improve the performence. but in any case needed to get
detais based on non primary key fields then we go for
secondary index . ie based on which non primary key fields
we need to fetch the data using select st for those fields
we create secondary index in sell.

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

PROGRAM TO CREATE INQUIRY IN SD USING BAPI 'BAPI_INQUIRY_CREATEFROMDATA'

4183


When the get cursor command used in interactive lists?

1054


B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.

2949


What is the function of a domain?

1152


What is at exit-command:?

927


What is table pool?

934


What is pretty printer?

978


How to create any functions? How to go about it?

1030


What are the check tables and value tables?

1098


What are the names of the function modules that will be generated upon activation of a lock object?

955


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

1231


What happens if a function module runs in an update task? : abap modularization

993


In which particular scenario we use sorted table and which particular scenario we use standard table?

1436


data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.

2262


What is the purpose of at first and at last?

1064