will where conditions in a sql query help improve performance?
Answers were Sorted based on User's Feedback
Answer / inder mohan
Yes, It will fetch only that data which will be in that
with criteria.
Inder Mohan Singh
9810058416
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is is a match code? : abap data dictionary
allinterview.com site is good for interview preparation or not?
I am looking for Professionals with 4+ yrs in ABAP HR Module (atleast 2yrs).
What event is trigger wen screen is displayed?Before displaying Initailization and Pressing enter At selection- Screen..............But at the selection displayed and we are entering values naa that time?
Companies in India which are working in SAP-ISU?
How can you call a page explicitly in smart forms?
What are the user groups?
I want to disable a field in selection screen so that it does not appear while displaying.How can i do that?wat wud be the code?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
What is logical database? : abap hr
In smart forms page no will be displayed as 2 of 15, 9 of 15 but while printing 10 of 15 it does not print correctly tell me how to handle this scenario.
what is the standard program to transport transaction variants and screen variants?