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

will where conditions in a sql query help improve performance?

Answer Posted / bala

If a table has an index for a key in the order
f1,f2,f3 then from the point of view of performance
the where clause should specify the fields in the
same order
select ..
from ...
where f1 = v_f1 and f2 = v_f2 and f3 = v_f3.

Note that the MANDT is implicitly compared first in the
order, and if using CLIENT SPECIFIED queries, ensure that
MANDT precedes the list.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Unpack command?

1135


What is the difference between data elements and domains?

1096


Can you define a field without a data element? : abap data dictionary

1148


What kind of financial periods exist in sap? What is the relavent table for that?

1118


What is your current client number?

1068


To find the date difference & excude saturday & sunday in between them

2013


What is the difference between call transaction and session method? : abap bdc

1216


What is abap work bench?

1332


In which table the material master data is stored?

1015


If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?

986


What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why?

1037


Is it possible to bring select option in module pool screens?

973


What is output determination?

1212


What is the use of at new statement ?

1785


dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?

2948