cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

View Vs Join

Former Member
0 Likes
3,360

Dear Experts,

What is the best way of improving the performance in a selection, VIEW(creating a DB View) or JOIN (Joining the DB Tables)?

Thanks,

Bala

View Entire Topic
Peter_Inotai
Active Contributor
0 Likes

As far as I know there is no difference in performance, only in reusability. DB View can be resued in several program. If you want to use it only in one of your program, join is easier....and you can use inner/outer join in you program, based on your needs.

Peter