what is the difference between view and join
Answer Posted / sukhbir
View and Join : two different way to join 2 or more
database table.
Join should be used to join 2 or 3 table small size table ..
performance will reduce in case of join b/w two large
database table.
View are always better then join in terms of performance....
Is This Answer Correct ? | 33 Yes | 9 No |
Post New Answer View All Answers
Differentiate between abap memory and sap memory?
How can you distinguish between different kinds of parameters?
What are the uses of table pool or table cluster.
Differentiate between table and template ?
Can a constructor be declared private? If yes then in which scenario?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
What are logical data bases used in hr module? : abap hr
What are the different functions used in sap script?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
out bound process code for quotation?
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary
What are the types of the software component being deployed in the sap?
What are the disadvantages of using explicit enhancement?
Explain the Inportance of pa40? : abap hr