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 exact functionality of the END-OF-SELECTION event? and in a report im using the END-OF-PAGE and END-OF-SELECTION events which one will triggers first?
how to upload logo in the smart forms
what is use of STOP stsment
Can a domain, assigned to a data element be changed?
Define structure in abap data dictionary?
in scripts if u want to add the field using itcsy structure iknow this concept,then i want to add some logic at a time in S.ORDER AND P.ORDER HOW,IF POSSIBLE WHERE U CAN ADD THE LOGIC, HOW?
in a loop of an internal table, what is the use of at first & at last statements?
What does an exec sql statement do in abap? What is the disadvantage of using it?
What is your current client number?
What is the syntex used to call a screen as dialog box (pop up)?
Table maintainence -- Transaction Code?
What is Field symbol?