what is the difference between view and join
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rupali
view is used to display only selected coloumns,it provides
restriction to display selected coloumns to the selected
user.
but in joins there nothin like restrictions,it is simple
join of two tables or more than two tables....
Is This Answer Correct ? | 15 Yes | 3 No |
Answer / gireesh
view is just virtually Create table and perform a task.
join is combine(group) two or more tables based on
conditions to collect data
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / visweswara
view contains 5 number of types.
in database view is joins 2 or more tables,
joins also do same work.
join is nothing but a database view.
view is generate the code and gives the result of table.
but our own 'join code' not genrate any programe but we
write reqired code for it and there is no external code is
genrated. thatsway join is better than view.
so we used to 'join' for write report programs.
Is This Answer Correct ? | 6 Yes | 17 No |
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization
What is an ABAP data dictionary?
Explain Commit and Roll back?
can we write a select query under end-of-selection event. and will it fetch data.
3 Answers Accenture, SAP Labs,
what is the procedure to report/submit the Back ground Program and the results to the PM?
Can a function group share its subroutine with all its function modules?
How do you document ABAP programs? Do you use program documentation menu option?
how many blocks can create in a ALV BLOCK LIST in ABAP?
What are the function modules used to create batch input session? : abap bdc
What are the aggregate objects in the data dictionary? : abap data dictionary
visibility section for class level and attributes level
i have cleared my technical round and manager round in cts but they told me u will get a call with in couple of days now i dont know about my status