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
What is the difference between free and refresh?
Explain pai and pbo.
How many types of data classes are there in sap?
What is the collect statement? How is it different from append?
What is transparent table?
What is the role of ‘refresh’ in internal table?
How is collect statement different from append?
Write an abap program for creation of customer enquiry using BAPI 'BAPI_INQUIRY_CREATEFROMDATA'.
What is a persistent class?
What is logo in sap script?
Can we create field without data element? If yes, how?
What is the differences between abap and ooabap. In which situation we useooabap?
how do you call third selection screen ?
What are the different types of abap reports in sap?
What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary