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.groups@xxxxxxxxx>
To: "Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>; "Postgres
General" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, May 09, 2007 12:08 PM
Subject: Re: [GENERAL] Views- Advantages and Disadvantages
On 5/9/07, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx> 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
