Re: Views- Advantages and Disadvantages

From: Ragnar <gnari(at)hive(dot)is>
To: Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Views- Advantages and Disadvantages
Date: 2007-05-09 09:05:29
Message-ID: 1178701529.10736.54.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On mið, 2007-05-09 at 12:46 +0530, Ashish Karalkar wrote:

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

>
> 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
>

2) UPDATES on a view are more tricky.

gnari

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-05-09 09:23:30 Re: backup and restore
Previous Message Ron Johnson 2007-05-09 09:03:12 Re: Views- Advantages and Disadvantages