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 |
How can we determine a vendor is Bloc/Unblock from the table LFA1?
At selection-screen on Fields output?
why abap/4 is 4th generation language ?
4 Answers Kansai Nerolac Paints Limited,
as a developer how u will decided which internal table we will use for requirement?
What are logical databases?
What is the function of a domain?
What are the page headers for secondary lists?
1) If the scripts are client dependent, what above driver program ? (client dependent / independent) 2. I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 3) Will 50,000 records be uploaded directly into APP's Server? 4) What is the button to change the variant in ALV ? 5) If your project is support project ? when is your implementation has completed ? 6)In start of selection, if we perform validation, what happens ? 7)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 8)How to transfer data which is coming from are report as output to another report 9)How to create standard text and how do u transfer it ? 10)What are the views when we are creating Material ?
Commonly used tables in MM and SD?
What are IDOCs?
How to get the spool number in smartforms?
What has to be done to the packed fields before submitting to a BDC session.