will join conditions in sql queries affect perfomance? how?
- 1 Answers
- 4141 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
Explain about workbench request and customization requests?
What are the main uses of the primary key?
how to modify the standard method as per your requirement
Explain the Types of Select statements?
What is the difference between ABAP and HR ABAP
Can we define our own match code id's for sap matchcodes? : abap data dictionary
What is a transport?
Can you define a field without a data element?
Explain the difference between domain and data element? What are aggregate object?
What is the difference between semi-monthly and Bi-weekly payroll area
what are the various types of parameters and how are they distinguished from one another?
What is meant by read lock? : sap abap data dictionary
How do you display a data in a detail list?
What do you mean by transparent tables in sap abap? : abap data dictionary
What are matchcodes?
