Re: Views- Advantages and Disadvantages

Thanks All for your replies,

But then dont we have any disadvantage of using View???

With Reagrds
Ashish...

----- Original Message -----
From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, May 09, 2007 2:03 PM
Subject: Re: [GENERAL] Views- Advantages and Disadvantages

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly