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
What is new enhancement framework?
What is abap?
Cds views
Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.
What is a database view? : abap data dictionary
What is abap dictionary or data dictionary? What is the transaction to access abap dictionary? : abap data dictionary
What is runtime analysis?
What data is contained in data dictionary? : abap data dictionary
Did you use buffering?
What is the difference between a dialog program and a report?
Define database layer? : abap data dictionary
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
What are the control break events in abap? : abap data dictionary
What is system-land-scape of your project?
What are the advantages of abap query tool?