On 5/9/07, Ron Johnson <ron.l.johnson@xxxxxxx> 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