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 |
When, how and how would you control changes to standard SAP objects.
If a table that is to be extended contains a long field, we cannot use append structures why? : abap data dictionary
What are the types of bdc s?
what is ment by view?how many types are there ?what are they?and what is the difference between data base view and projection view?
pls if any one have idea ,reply as soon as possible 1.Allied solution group inc. is a genuine company or not ? 2.what is update module. 3.Transaction: scc3 what it is?
Performance tuning. How can you know which line of code taking long time to execute?
when we are using at new?should we use this inside the loop or outside?what will be the effect?
what is diff b/w user exits and cutomer exits
5 Answers Deloitte, iYogi Technical Services,
what is the Difference Between session and call transaction?
What is Field group?
Hi all, For the past 1 year, I have been trying for job in SAP as a fresher, but no calls,no interviews.I know showing fake experience is unethical, but i dont have any alternative.After showing fake experience now iam getting calls,but still i feel guilty.Friends i have some questions. 1. If suppose i tell the truth in interview that i have shown fake experience,what would be the interviewer's reaction? Will accepting the fake go negative against me? 2.Whether i should accept the fake in technical round itself? (or) Maintain the fake,prove myself strong in technical round &then accept the fake in HR round? 3.Some of my friends(who have shown fake and well settled in MNC's ) are telling that during interview u should never accept as fake i.e., u should act confidently as a real experienced guy.Even if the interviewer come to know that u r a fake guy, but seeing ur confidence level ,he/she will select u ? Is it true? Friends, particularly interviewer's , HR's please give me ur valuabe solutions.Other's suggestions are also welcome.
what is the difference between interface and global diffinations in smartforms?