will where conditions in a sql query help improve performance?
Answers were Sorted based on User's Feedback
Answer / inder mohan
Yes, It will fetch only that data which will be in that
with criteria.
Inder Mohan Singh
9810058416
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is the effect on Customer Exits and User Exits maintained in a system on Up-gradation .
What is the maximum No. Of structures that can be included in a table or structure. : abap data dictionary
What is For-period and In-period
how to get the pop up screen ?the first screen as display button ,if we press that button then pop up screen has to come with same information?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
How can I make a differentiation between dependent and independent data? : abap hr
Can we use binary search in internal table sorted in decending order ? if no why?
10) How to get Item Header in Sales Order?
performance tuning concepts
How to specify a client for database table processing?
How to handle error in session method? : abap bdc
What are the FM's you used in ALV?
one time loading 10000 records?