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
Can we create an abap program without using y or z?
What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr
Explain how to write a bdc - how do you go about it?
Do we have to migrate all sapscript forms to smart forms?
SAP query how to use end users?
What are the 3 types of function modules in sap?
What are the major steps will you use for tuning?
Can you define a field without a data element?
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
What is the difference between get and get late?
Difference between sy-tabix and sy-index? Where it is used?
What is the significance of the screen number ‘0’?
What two statements would be used to exchange data between programs using abap memory?
How many types of buffering? : abap data dictionary
Differentiate between table and template ?