ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  ABAP
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question
will join conditions in sql queries affect perfomance? how?
 Question Submitted By :: Neerajalaxmi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: will join conditions in sql queries affect perfomance? how?
Answer
# 1
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 ?    1 Yes 0 No
Siddharth Samal
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
How can you call a subroutine which is located in program A from program B? CSC4
what is advantages and disadvantages in call by value and call by reference Wipro4
Hi all Could u please tell me the answers for following questions, Why we need IDocs...? What is the purpose of IDocs...? Thanks in Advance, Sanjeev.K Keane-India-Ltd4
what is function group? Difference between function group and FM?  3
Is der any other way or tcode to process the session except SM35? IBM4
I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it?  1
the sap standard SAPSCRIPT for picking a list ?  1
Internal table itab contains some records. If the code is like this : LOOP AT ITAB. APPEND ITAB. ENDLOOP. What ill be the result?? Accenture3
How to get the no of records using select statement?  3
what are the events used in LDB?  3
How to create MEDRUCK form?  1
At selection-screen on Fields output?  1
what is the difference between templates and tables. CTS1
1.How to pass the variables to form? 2. How did you test the form you developed? 3.what are the outpout types and tcodes? 4.what mean by performance analysis?  1
in script can i print the back page of a paper  1
what if F4 key for? TCS2
how to create lock object HCL1
How do you copy the script from source alert? Satyam1
what is need of function group for function modules whereas there is no need of f.group for subroutines? IBM1
What is a batch input session?  2
 
For more ABAP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com