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

Explain Catch Command in ABAP?

1282


What is the maximum number of structures that can be included in a table or structure

1061


What is the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary

1128


What is an update task? : abap modularization

1076


What is cts and what do you know about it? : abap hr

1226


can anyone please tell me, in orient paper mill project which fields exits for creating report.

1704


Can a domain, assigned to a data element be changed? : abap data dictionary

1054


How do we assign dynamic views while creating material master and generating bdc? : abap bdc

1158


Do you know any other patterns if yes.. explain

1306


In sap scripts, how will you link form with the event driven?

990


What is the collect statement? How is it different from append?

1088


​​What is view proxy in abap?

1267


What is direct input method ?

1949


Explain the Inportance of pa40? : abap hr

1063


Explain the difference between tables and structures?

992