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 an Unpack command?
What is the difference between data elements and domains?
Can you define a field without a data element? : abap data dictionary
What kind of financial periods exist in sap? What is the relavent table for that?
What is your current client number?
To find the date difference & excude saturday & sunday in between them
What is the difference between call transaction and session method? : abap bdc
What is abap work bench?
In which table the material master data is stored?
If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?
What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why?
Is it possible to bring select option in module pool screens?
What is output determination?
What is the use of at new statement ?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?