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

What is partner selection?

816


What are the types of table fields in the sap abap?

852


What are extracts?

765


In events, start-of-selection is a default event. When we have to use this event explicitly? Why?

787


Why do we use types statement in abap programming?

867


What is the meaning of sap r/3?

834


What are the different functions used in sap script? What are the parameters used in each function?

859


What are the attributes of the data? : abap data dictionary

840


What do you mean by transparent tables in sap abap? : abap data dictionary

746


what is mean be On Change of in Control Break statement

1058


Module Pool Programming: Events and Table Control handling.

1071


How do you backup Sapscript layout sets? Can you download and upload? How?

813


What is the structure of the bdc table? : abap bdc

951


Under Data Transfer Portion of ABAP, what do you mean by DX Project

2065


Why do we use events and actions in web dynpro?

772