|
I think in this case the biggest advantage is probably the ability to index the view/ You can create an index combining all of the joins that you do by hand, but it's a little easier to maintain if you just index the view. IMO.
If you're just selecting there probably isn't much of a difference except that using a view makes it easier to create an ad-hoc reporting system. Well, a somewhat ad-hoc reporting system anyway. You define the columns that the user can select from, but the users selects the columns to query against.
|