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 |
PLEASE TELL ME SD AND MM FLOW/CYCLE WITH TRANSACTION CODE AND CORRESPONDING TABLE TO BE UPDATED?
What you modified in Purchase Order?
Suppose i have table with 2 columns say 1st with Numerics and 2nd with words like 1 for one and 2 for two......so.if i want to change the 9 numeric word as some twenty...how?
What are the transaction codes to create the Infotypes
Elements of Main window and is Main window compulsory in Sap script ?
What is “call mode”?
What is the difference between select single and select upto 1 rows?
What are standard layouts sets in the sap script?
Explain how to create any functions? How to go about it?
List the events in abap/4 language?
who is vendor?
what will happen in Initialization event?