Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between view and join
- 4 Answers
- 29773 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
Explain what are standard layouts sets in the sap script?
What is constructor expression in nw abap 7.4?
What are the two levels in defining a match code? : abap data dictionary
What are the personnel administration related infotypes? : abap hr
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
What are Table control and tab strip control in dialog programming ?
What are the differences between session method and call transaction method? : abap bdc
How can we set the table spaces and extent sizes? : abap data dictionary
What is table pool?
What abap statement will trigger list generation?
What is the structure of the bdc table? : abap bdc
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
What are the different types of data dictionary objects? : abap data dictionary
Can matchcode object contain ids with different update types? : abap data dictionary
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
