On 5/9/07, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> wrote:
> > 1) Performance : If a view is defined by complex multitable
> > query,then simple query against that view becomes a coplecated
> > join, and it may take a long time to complete
> I don't see that as relevant, since we know which objects are tables
> and which are views. But maybe that's just our site.
Plus, to retrieve the same information w/o the view he'd
still have to have the same multi-table query which would
a) take as long to run and b) take much longer to type :)
Cheers,
Andrej