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
In the `select' statement what is group by ?
What are the dynamic actions and how to configure it? : sap abap hr
How to define selection screen?
How we format the data before before write statement in report ?
What are the different methods of passing data?
Explain how many types of tables exist and what are they in data dictionary?
How the transaction that are programmed by the user can be protected?
What is sap luw or update transaction?
In a loop of an internal table, what is the use of at first & at last statements?
How to get that a secondary index is attached to a select query?
What are the organizational related Infotypes
What is the difference between upload and ws_upload ? : abap bdc
How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.
how 2 create the normal form by using functional module
On abap: did you set up a workflow? Are you familiar with all the steps for setting up a workflow?