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
Explain Catch Command in ABAP?
What is the maximum number of structures that can be included in a table or structure
What is the significance of technical settings (specified while creating a table in the data dictionary)? : abap data dictionary
What is an update task? : abap modularization
What is cts and what do you know about it? : abap hr
can anyone please tell me, in orient paper mill project which fields exits for creating report.
Can a domain, assigned to a data element be changed? : abap data dictionary
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
Do you know any other patterns if yes.. explain
In sap scripts, how will you link form with the event driven?
What is the collect statement? How is it different from append?
What is view proxy in abap?
What is direct input method ?
Explain the Inportance of pa40? : abap hr
Explain the difference between tables and structures?