Re: Views- Advantages and Disadvantages

Thanks Andrej
for your replay

I have found out some of them n are as follows, but I want more reasons
for not using views . I only got one

Advantages:

1) Permission to user can be given to access the database only
through view containing specific data the user is authorized to see

2) View convert multiple table queries into single table
queries

3) Views give personalized view

4) Views provide consistent unchanged image even if the underlying
table columns changed.

Disadvantages:

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

----- Original Message -----
From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>; "Postgres
General" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, May 09, 2007 12:08 PM
Subject: Re: [GENERAL] Views- Advantages and Disadvantages

> On 5/9/07, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com> wrote:
>> Hello All,
> Hi,
>
>> Can anybody please point me to Advantages and Disadvantages
>> of using view
> The most obvious advantage (for me, anyway) is to restrict which
> columns a user can see in a table.
>
> I'm sure there are others.
>
>
>
>
>> With Regards
>> Ashish...
> Cheers,
> Andrej
>
>
> --
> Please don't top post, and don't use HTML e-Mail :} Make your quotes
> concise.
>
> http://www.american.edu/econ/notes/htmlmail.htm
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster