Re: Views- Advantages and Disadvantages

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>, "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>, "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Views- Advantages and Disadvantages
Date: 2007-05-09 19:02:05
Message-ID: D425483C2C5C9F49B5B7A41F894415470100063F@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Ashish Karalkar
> Sent: Wednesday, May 09, 2007 1:36 AM
> To: Andrej Ricnik-Bay; Ron Johnson
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>
> Thanks All for your replies,
>
> But then dont we have any disadvantage of using View???

Views can hide important information from the optimizer (especially
index information).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo de Moraes Serpa 2007-05-09 19:11:08 Re: Audit-trail engine: getting the application's layer user_id
Previous Message Lou O'Quin 2007-05-09 18:55:20 re Referential Integrity Flash Tutorial