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.groups@gmail.com>
To: "Ron Johnson" <ron.l.johnson@cox.net>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, May 09, 2007 2:03 PM
Subject: Re: [GENERAL] Views- Advantages and Disadvantages


> On 5/9/07, Ron Johnson <ron.l.johnson@cox.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@postgresql.org so that your
>       message can get through to the mailing list cleanly