will where conditions in a sql query help improve performance?
- 2 Answers
- 4572 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
How can I get ascii value of any letter? Is there any function?
What is projection view?
visibility section for class level and attributes level
What is the tcode to create indexes?
What are the disadvantages of using explicit enhancement?
What is buffering allowed but switched off?
What are the uses of secondary indexes?
Lock objects and what are parameters of ENQUEUE FM?
What two statements are required in an abap program to output an icon using a write statement?
What are the commands used for interactive reports?
What is the function of a domain?
What are the parameters in bdc_open_group? : abap bdc
What are the types of indexes in abap?
What is the difference between ABAP and HR ABAP
How can we set the tablespaces and extent sizes ?
