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 |
where u can create the rfc function module?
Scenario 1: I am uploading 1000 records using session method. I have an error in 950th record. What will happen and howmany records will upload? Scenario 2: I am uploading 1000 records using Call Transaction method. I have an error in 950th record. What will happen and howmany records will upload?
what are the components of bdc?
What are the functional modules used in sequence in bdc? : abap bdc
Diff b/w ECC6.0 ,ECC 5.0 and 4.7......
How do you populate data into a multiple line field?
Does every abap/4 have a modular structure?
what is the difference between user-exit & BADIs?
In order to upload purchase order details, how you handle multiple values for a single field?
if take one table with max no of records,in that i transfer only three records to quality r production r anywhere how it is possible?
What is the difference between macro and subroutine?
What is the full form of "SPA/GPA" Paramaters.