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 are the types of the programming language used in the sap abap software?
wat is the difference between A-gate & W-gate?where are they used?
What is the difference between a structure and an append structure?
What is macro? : abap hr
Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
How do you find the tables to report from when the user just tell you the transaction he uses? And all the underlying data is from SAP structures?
Rp_provide_from_last contains how many parameters ? : abap hr
Explain the Types of Select statements?
Explain the different types of mode (run code) in call transaction method?
How to creat transactions? : abap data dictionary
Can we define our own match code id's for sap matchcodes? : abap data dictionary
What are table clusters?
Sales Order Information Report that lists information like sales order no, Item no, material no, Quantity, Quantity unit, Net value, Currency,Sub Total, Grand Total. plz mention the detail coding Tahnks, Rahul
When to use logical database?
What are the restrictions on subscreens?