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


Please Help Members By Posting Answers For Below Questions

Difference between BDC vs Direct Loads?

662


What is the use of abap data dictionary? : abap data dictionary

584


What are function modules?

580


Explain how to write a bdc - how do you go about it?

609


What is the logo in sap script?

574






How do you Export a session ?

1594


What are the parameters used in each function?

601


Mention the various databases integrities?

614


What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc

559


What are the events in abap/4 language? : abap hr

616


How to eliminate duplicate entries in internal tables? : abap data dictionary

786


What is the role of ‘refresh’ in internal table?

592


What are matchcodes?

555


What is locking ?

604


What is an internal table?

726