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 |
How to find the status of failure a IDOC
Can you transport variants of multiple programs in one step?
What is the difference between end-of-page and end-of- selection?
have you used performance tunig?what major steps will you use for those
What is abap?
Difference between open sql and native sql? : abap data dictionary
how to debug the smartform? plz tell me step by step process or screen shots?
Which type of tables used this buffer?
Functionality of Edit call..?
What does hide statement do?
how can u write in single program call transaction and session method logic? if u write logic in call transaction ,is there any errors ? how can u see in session ?
Hi all Could u please tell me the answers for following questions, Why we need IDocs...? What is the purpose of IDocs...? Thanks in Advance, Sanjeev.K