will join conditions in sql queries affect perfomance? how?
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
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
How do you do bdc for a table control? : abap bdc
What is partner selection?
What are the system table used in abap?
what is bapi,badi,bdc,ale idocs?
How to get that a secondary index is attached to a select query?
after creating lock object if does n't access record by second user what should we do?
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
What are plan versions used for? : sap abap hr
How table control cn be generated using bdc? : abap bdc
Sy index and sy tabix
What are the attributes of the data? : abap data dictionary
What is Field group?
How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?
What is its? : abap hr