what is the difference between view and join
- 4 Answers
- 28365 Views
- Anand Group, IBM, I also Faced
- E-Mail Answers
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
How many types of tables exists and what are they in data dictionary?
What are the advantages and disadvantages of using views in abap programming ?
How to create user interfaces for lists?
What is a 'z' report?
Can you define a field without a data element?
What are the types of data types in the sap abap?
What is logical database? : abap hr
How to Modify Layout set for RVORDER01 for printing sales order confirmation. plz mention the detail coding Tahnks, Rahul
8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?
What is asynchronous and synchronous update?
Find the scenario and give the result: a, b, c are employees, where a, b will get basic, hra, da. C gets basic and da. How to group for the allowances? : sap abap hr
What is difference between inner join and outer join?
What is pass by value and what is pass by reference? Which is better?
What are conversion routines? : abap data dictionary
hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.
