will join conditions in sql queries affect perfomance? how?
Answer / 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 |
What is the difference between report and script?
WHAT IS PEFORMANCE TUNING?
How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?
What is the difference between bdc_okcode and bdc_cursor? : abap bdc
Can we modify data in data base table using view?
What is an index ? Types of index and there uses ?
what is the button to change the variant in alv?
1 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What is a collect statement?
What is difference between inner join and outer join?
17) How will you validate selection screen elements?
What are the different types of views in sap? : abap data dictionary
What is SAPscript and layout set?