Interested to Buy Any Domain ? << Click Here >> for more details...
will where conditions in a sql query help improve performance?
- 2 Answers
- 4963 Views
- I also Faced
- E-Mail Answers
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 an on”*-input filed” statement?
Can you create an internal table dynamically?(at run time)
What is match code? : sap abap hr
Define batch input session?
A subroutine can contain nested form and endform blocks. State true or false. : abap modularization
What are the time related infotypes? : abap hr
Name the abap/4 modularization techniques? : abap modularization
What do you mean by cluster tables in sap abap? Also explain what do you mean by table cluster? : abap data dictionary
What are the types of the software component being deployed in the sap?
What are datasets in abap?
Of the two call transaction and session method, which is faster?
In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?
How many lists can a program can produce?
difference between Valuation type and valuation category?
What is meant by exclusive, not cumulative lock? : sap abap data dictionary
