Interested to Buy Any Domain ? << Click Here >> for more details...
will join conditions in sql queries affect perfomance? how?
- 1 Answers
- 4863 Views
- I also Faced
- E-Mail Answers
Answer Posted / siddharth samal
THAT ENTIRELY DEPENDS ON THE CRITERIA YOU HAVE USED. IF THE
WHERE CONDITION HAVE ALL THE PRIMARY KEY FIELD THEN THE
PERFORMANCE WILL NEVER BE SLOW. ITS ONLY ADVISIBLE NOT TO
HAVE MORE THAN 5 TABLES IN THE JOIN OR ELSE THE PERFORMANCE
WILL BE SLOW.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the two ways for restricting the value range for a domain? : abap data dictionary
What does an exec sql statement do in abap? What is the disadvantage of using it?
Can a constructor be declared private? If yes then in which scenario?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
What do you mean by batch data communications programming?
1. what is IDOC monitoring ? what is the tcode used for idoc monitoring ? 2 . what is change pointer in ale ?
What are the client dependant objects in abap / sap?
what is code to upload cost centers through call trans. and procedure
What are the function of the transport system and workbench organiser? : abap data dictionary
What is meant by performance analysis? Have done anything to improve the performance?
Does the call transaction method allow multiple transactions to be processed by sap?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What is an update type with reference to a match code id?
What are the different functions used in sap script?
How do you validate the selection criteria of a report? And how do you display initial
